Database – (rows or records, columns or fields)?

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.

Leave a Comment