Hi

I'm using the following command script to copy table structures within my SQL Server Database:

select * from myDatabase.dbo.myTable1 into myDatabase.dbo.myTable2

This works fine, however, is there any way I can do this and ensure that the new copy has the same field defaults as the parent table?

Regards