Copy Table Structure With data and Without Data in Teradata

Copy Table Structure with Data 

CREATE TABLE database.tablename_current AS  database.tablename_source WITH DATA;

  

Copy Table Structure without Data 

CREATE TABLE database.tablename_current AS  database.tablename_source WITH NO DATA

Comments