create a new table from another table

Question

Shankar M · Answer

Hi Pawan,You can try,and In SQL Server,SELECT * INTO NEWTABLE FROM OLDTABLE WHERE 1 = 0In Oracle (CTAS -Create Table as Select)CREATE TABLE NEWTABLE AS SELECT * FROM OLDTABLE WHERE 1 = 0Here 1 = 0 is the condition that is never satisfied, So the data is not inserted into the new table.Thanks,Shankar

Anonymous User · Answer

Hi Pawan,
You can use this syntax,
CREATE TABLE new_table
and  AS (SELECT * FROM old_table);
Visit this link for more syntax:
http://www.techonthenet.com/sql/tables/create_table2.php

forum

create a new table from another table

Pawan kumar

Can you answer this question?

2 Answers

Liked By