SQL Statements | Data Definition Language | Teradata Vantage - Introduction to SQL Data Definition Language Syntax and Examples - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

Using Teradata Vantage™ - SQL Data Definition Language - Syntax and Examples

This document is intended for those responsible for designing, maintaining, and using Teradata Vantage™. For example:
  • System administrators
  • Database administrators
  • Security administrators
  • Application programmers

Why Would I Use this Content?

To learn about the Teradata Vantage SQL statements used to define or restructure Teradata Vantage.

Teradata SQL is an ANSI compliant product. Teradata has its own extensions to the language.

How Do I Use this Content?

To learn the purpose and syntax of each Teradata Vantage DDL statement and see examples and references to related information.

How Do I Get Started?

Start with SQL DDL Statements.

References to Other Relevant Content

For supplemental information about Teradata Vantage DDL statements, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.

For information about temporal tables, see Teradata Vantage™ - Temporal Table Support, B035-1182 and Teradata Vantage™ - ANSI Temporal Table Support, B035-1186.

For information about the Teradata Vantage statements used to manage access to database objects and data in the system, see Teradata Vantage™ - SQL Data Control Language, B035-1149.

For information about the Teradata Vantage statements used to query or update a database or analyze queries and query workloads, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.