Home arrow Technical Tips arrow Oracle arrow Copy Table Columns and Data
Copy Table Columns and Data Print E-mail
As you may know, in Oracle the syntax from creating a table that is the same as another is:

create NEWTABLE as select * from TABLE

In SQL Server, the syntax is slightly different:

select * into NEWTABLE from TABLE

Note: This will not copy indexes, constraints, triggers, or other attributes of the table. It will copy the column names, data type, and data only.