Create Table As
Jump to navigation
Jump to search
To create a table identical to another table, yet without any of the data, simply use the following syntax:
CREATE tableA AS (SELECT * FROM tableB WHERE 1=2);
