![]() | Databases Stub‑class (inactive) | ||||||
|
Is this article about relational databases, column databases, or perhaps something else? The article has poor structure and no clear subject.Fjerdingen (talk) 19:38, 12 June 2018 (UTC)
Fields
editThe Field section needs clarifications.
In SQL a field is not the same as a column. ISO/IEC 9075-2:2016(E) - the current ISO/ANSI SQL standard - explains the differences (and similarities):
"The terms column, field, and attribute refer to structural components of tables, row types, and structured types, respectively, in analogous fashion. As the structure of a table consists of one or more columns, so does the structure of a row type consist of one or more fields and that of a structured type one or more attributes."
Example:
SELECT ('a', 'b') c FROM tablename;
The above query returns one single column, named c.
The row type column c has two fields. Fjerdingen (talk) 21:56, 26 January 2023 (UTC)