Difference between revisions of "Create Table As"
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);