COPY TABLE STRUCTURE alone 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 NO DATA; 


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


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 NO DATA; 

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