Talk:Column (database)

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
The 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)