Database - (rows or records, columns or fields)?
In database terminology:
What is the difference between a row and a record?
Likewise, aren't columns and fields the same thing?
On the blog Joe Celko The SQL Apprentice , I noticed that the banner mentions that they are different things.
Answer
Row and record can arguably be considered as the same thing.
Fields and columns are different, a field is the intersection of a row and a column.
i.e. if your table has 10 rows and 10 columns, it has 100 fields.
When you create a table using DDL statements, you define columns (metadata). When you add rows using DML statements, you define rows and their fields.