create a new table from another table

Pawan kumar 2457 10-Mar-2011

sir i want to create new table from another table (only structure of table) and then record of table.

mssql server

Updated on 09-Apr-2013

Can you answer this question?

Answer

09-Apr-2013

Hi Pawan,

You can try,

In SQL Server,

SELECT * INTO NEWTABLE FROM OLDTABLE WHERE 1 = 0
In Oracle (CTAS -Create Table as Select)
CREATE TABLE NEWTABLE AS SELECT * FROM OLDTABLE WHERE 1 = 0

Here 1 = 0 is the condition that is never satisfied, So the data is not inserted into the new table.

Thanks,

Shankar

11-Mar-2011

Hi Pawan,
You can use this syntax,

CREATE TABLE new_table   AS (SELECT * FROM old_table);

Visit this link for more syntax:

forum