Appendix F. Glossary


Another name or term for a table or column.


American National Standards Institute.


A set of menus, forms, reports, and code that performs a business function using a database.


An area in memory for editing or execution of SQL.

Cartesian product

The result of not joining tables in the WHERE clause of an SQL statement. When tables in a query are not joined, every row in one table is paired with every row in all other tables.


The client is typically a PC, but can be another server that is dependent on another computer for data, services, or processing.


A part of a table that has a name and a specific data type.


Makes changes to data permanent.

composite index

An ...

Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.