CREATE TABLE As Old Table in Teradata

Syntax
CREATE TABLE New_Table AS Old_Table WITH DATA;
CREATE TABLE New_Table AS Old_Table WITHOUT DATA;


Above syntax is used to create a New table whose structure is same as Old table and the With Data option copies the full set of data from old table while without data copies the table structure alone.

Short Form
CT New_Table AS Old_Table WITH DATA;