16.10 - Defining Tables - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Release Number
Release Date
June 2017
Content Type
Programming Reference
Publication ID
English (United States)

Use the CREATE TABLE statement to define base tables. This SQL statement specifies a table name, one or more column names, and the attributes of each column. The CREATE TABLE statement can also specify data block size, percent free space, and other physical attributes of the table.

The CREATE/MODIFY USER and CREATE/MODIFY DATABASE statements provide options for creating permanent journal tables.