Sams Teach Yourself SQL

Glossary

alias

Another name or term for a table or column.

ANSI

American National Standards Institute.

application

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

buffer

An area in memory for editing or execution of SQL.

cartesian product

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

client

The client is typically a PC, but it can be another server that is dependent on another computer for data, services, or processing. A client application enables a client machine to communicate with a server.

column

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

COMMIT

Makes changes ...