Primary Key

Numbering of rows in accordance with the order of values of a primary key

Numbering of a query result set

Entity Integrity

Data Definition Language (SQL DDL)

Referential integrity: FOREIGN KEY

Data Definition Language (SQL DDL)