>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
I found (not tried) this script
http://www.mindsdoor.net/DMO/DMOScripting.html
If it's not broken, fix it until it is.
My Blog