COPY TABLE STRUCTURE and DATA in Teradata

You can create the tables with the structure and with or without data of a previously existing table.

Syntax:
CREATE TABLE database.tablename_now AS
 database.tablename_previous WITH DATA; 


The below syntax will work exactly as above
CREATE TABLE database.tablename_now AS database.tablename_previous 
WITH NO DATA; 
INSERT INTO database.tablename_now SELECT * FROM  database.tablename_previous 


Forget code gives database name also in the syntax to tell that the data sharing is possible even between the different databases

Note:
Please note that the CREATE TABLE AS statement will not work if the source table has referential integrity constraints or any columns are defined as identity columns.

Example:
CREATE TABLE Prod.employee_now AS
 Uat.employee_previous WITH DATA; 

CREATE TABLE Prod.employee_now AS
Uat.employee_previous WITH NO DATA; 
INSERT Prod.employee_now SELECT * FROM Uat.employee_previous