Difference between revisions of "Create Table As"

From NazimWIKI
Jump to navigation Jump to search
(Created page with "To create a table identical to another table, yet without any of the data, simply use the following syntax: <blockquote><pre> CREATE tableA AS (SELECT * FROM tableB WHERE 1=2...")
 
(No difference)

Latest revision as of 21:55, 8 November 2019

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);