I want to copy all my table definitions for all my tables from one SQL Server 2005 to another SQL Server 2005. I don't want the data copied. How would I do this?
I can generate script for each table, copy it, and paste it into the new server's script window using the Server Management Studio. There must be a better way?