Talk:Column (database)

	This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases articles
Stub	This article has been rated as Stub-class on Wikipedia's content assessment scale.

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

Fields edit

Latest comment: 1 year ago1 comment1 person in discussion

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

Add topic