34,333
edits
Changes
→Primary Keys
''Rows'' are also somethings referred to as ''records'' and these terms can generally be used interchangeably.
== Introducing Primary Keys ==
Each database table must contain one or more columns that can be used to uniquely identify each row in the table. This is known in database terminology as the ''Primary Key''. For example, a table may use the bank account number column as the primary key. Alternatively, a customer table may use the customer's social security number of the primary key.