Creating dublicate table : LUSENET : SQL Server Database Administration : One Thread

Dear Sir,

How to create a table same as another table with records. I saw a query in oracle is, create table tablename as select * from tablename but this query is not working in sqlserver 7. Can you please send me what is the correct query in sql server7?

Thanks and regards, Rasheed

-- Anonymous, November 20, 2004


Hi Rasheed,

You could use "select * into from " to create a new table using the existing table with records. But you need to ensure that "Select into/bulkcopy" database option is switched on for this.

Hope this helps.


-- Anonymous, November 22, 2004

Moderation questions? read the FAQ