Structured Query Language [SQL]

FOREIGN KEY

A field (or collection of fields) in one table that uniquely identifies a row of another table.

Tuple

A row in a database.

PRIMARY KEY

A unique identifier for each record in a database table.

INSERT

This SQL statement is used to add new data into a database.

CREATE

This SQL statement is used to create a table in a database.

DROP

This SQL statement is used to delete a table from a database.

DELETE

This SQL statement is used to delete rows in a table.

WHERE

This SQL statement is used to return data which meets specified requirements.

SELECT

This SQL statement is used to select data from a database.

ORDER BY

This SQL statement is used to sort the result-set by one or more columns and is ascending by default.

UPDATE

This SQL statement is used to update data records in a database.

CASCADE

Whatever happens to the master table, will effect the child table.