Column vs Field: have I been using these terms incorrectly?
32
votes
5
answers
39134
views
I feel kind of embarrassed here, I've always used the terms "column" and "field" completely interchangeably, which recently caused some confusion in a technical discussion.
I was told, though, that this wasn't correct, that it should be (translating each term into spreadsheet terminology, ignoring data types and all the other stuff that make databases useful):
* Database Column: like a spreadsheet column
* Database Record: like a spreadsheet row
* Database Field: like a spreadsheet "cell" (a specific column of a specific row)
Is this right? I could have sworn that column and field are used more interchangeably than that. I certainly have been.
So we *don't* add *fields* to a table, we add *columns* to a table, and fields are only relevant when talking about data within a record?
Other thoughts on column vs field?
Edit: to clarify, the current context is MS SQL Server. My background before SQL server was MS Access, which might influence my use of these terms.
Asked by BradC
(10023 rep)
May 21, 2014, 04:28 PM
Last activity: Jan 15, 2019, 09:42 AM
Last activity: Jan 15, 2019, 09:42 AM