A common attribute of two tables is called a foreign key if it is the primary in one table.

Part of SQL which creates and defines tables and other database objects, is called DDL.

Part of SQL which accesses and manipulates data in tables, is called DML.

Part of SQL which controls transactions, is called TCL.