SQL statements enable you to define database objects, define user access to those objects, and manipulate the stored data.
These are the families of SQL statements:
- Data Definition Language (DDL) statements
- Data Control Language (DCL) statements
- Data Manipulation Language (DML) statements
SQL also has HELP and SHOW statements that provide help about the following:
- Database object definitions
- Sessions
- Statistics
- EXPLAIN request modifier
- SQL statement syntax
- SQL used to create tables
The following sections contain information about the functional families of Teradata SQL.