The SQL language allows you, using SQL statements, to define database objects, to define user access to those objects, and to manipulate the data stored.
These functions form the principal functional families of SQL statements:
- Data Definition Language (DDL) statements
- Data Control Language (DCL) statements
- Data Manipulation Language (DML) statements
In addition, SQL provides HELP and SHOW statements that provide help about database object definitions, sessions and statistics, the EXPLAIN request modifier, SQL statement syntax, as well as displaying the SQL used to create tables.
The following sections contain information about the functional families of Teradata SQL.