Can I use… T175, “Generated columns”

1. Limited constraint support
2. Requires explicit data type: col_name integer generated always as …
3. Requires explicit data type: col_name integer generated always as … • Supports storage options • Limited constraint support
4. Supports storage options
5. Requires explicit data type: col_name integer generated always as … • Requires storage option stored
6. Only without data type: col_name integer generated always as … • Only without keywords generated always • Limited constraint support
7. Supports storage options • Data type not honored if specified • Limited constraint support

Related

• Non-standard extension: storage option virtual/stored/persisted/persistent

• T174, “Identity columns”

• T180, “System-versioned tables”

Normative References

T175, “Generated columns” is defined in ISO/IEC 9075-2:2016. It first appeared in ISO/IEC 9075-2:2003.