Copying table structure not data
SQL>
SQL> CREATE TABLE myTable (
2 Name VARCHAR(50) PRIMARY KEY NOT NULL,
3 PhoneNo VARCHAR(15) DEFAULT 'Unknown Phone',
4 SSN VARCHAR(15) NOT NULL,
5 CHECK (SSN LIKE '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'));
Table created.
SQL>
SQL>
SQL> CREATE TABLE My_myTables AS SELECT * FROM myTable
2 WHERE 1=0;
Table created.
SQL>
SQL> drop table myTable;
Table dropped.
SQL> drop table My_myTables;
Table dropped.
Related examples in the same category