Virtual column
≈ 1 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
In relational databases a virtual column is a table column whose value(s) is automatically computed using other columns values, or another deterministic expression. Virtual columns are defined of SQL:2003 as Generated Column, and are only implemented by some DBMSs, like MariaDB, SQL Server, Oracle, PostgreSQL, SQLite and Firebird (database server) (COMPUTED BY syntax).
In relational databases a virtual column is a table column whose value(s) is automatically computed using other columns values, or another deterministic expression. Virtual columns are defined of SQL:2003 as Generated Column, and are only implemented by some DBMSs, like MariaDB, SQL Server, Oracle, PostgreSQL, SQLite and Firebird (database server) (COMPUTED BY syntax). [GENERATED ALWAYS] AS ( ) [VIRTUAL | PERSISTENT] [UNIQUE] [UNIQUE KEY] [COMMENT ] type is the column's data type expression is the SQL expression which returns the column's value for each row text is an optional column comment column_name [type] COMPUTED BY (expression) or the industry standard column_name [type] GENERATED ALWAYS AS (expression) ==References== Computed Columns in SQL Server 2008
Text derived from https://en.wikipedia.org/w/index.php?oldid=1335033076 under CC BY-SA 4.0; modifications have been made.