Creating dublicate tablegreenspun.com : 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.
Sudhakar
-- Anonymous, November 22, 2004