Create Table As

From NazimWIKI

Revision as of 21:55, 8 November 2019 by Admin (talk | contribs) (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...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

Retrieved from "http://www.nazimcricket.com/wiki/index.php?title=Create_Table_As&oldid=25"