15.00 - 15.10 - Types of SQL Statements - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

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.