What’s the Difference
between a Column and a Field ?
Field and columns :
A field contains a single attribute, or property, of
any object,
such as description, price, cost, quantity, etc, stored in a row, or record.
A “column” is the
collection of all of one fields in all of the rows in a table.
In other words, all of the “LastName”
fields in the table from the “LastName” “column”
Click for examples of fields and columns
The subtle
difference between the meaning of a “field” and a “column”
can be seen in the following illustration :
What’s in a name ?
Field and column names :
The field name is simply the name of the field.
The column name is
usually the name of the field,
but can be changed (“aliased”) to be more informative to the user,
because field names can sometimes be kind of cryptic.