15.00 - 15.10 - Types of SQL Statements - Teradata Database

Teradata Database Introduction to Teradata

Teradata Database
Release Number
Content Type
User Guide
Publication ID
English (United States)
Last Update

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.