What command is used to create a table by copying the structure of another table?
CREATE TABLE .. AS SELECT command Explanation : To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following. CREATE TABLE NEWTABLE AS SELECT * FROM EXISTINGTABLE WHERE 1=2; If the WHERE condition is true, then all the rows or rows satisfying the condition will be copied to the new table.
Related Questions
- What is the Attempts field in the CallList table used to determine?DGA-20045Interaction Dialer 1.3 Software Revision B and CWhat is the Attempts field in the CallList table used to determine?
- I already used the 4 primary fdisk partition table entries. Can I create a partition for Solaris within my extended partition?
- What information does the Tax Rates table present, and how can it be used?
