I think I may be missing something really obvious here. I want to create a copy of a table without the data. The tables are dynamic and so I can't look at a given column and do WHERE ID = -1 or something similar. Some of the tables may be very large. What I'd like to do is effectively run a create table script with a different name. The indexes, pk's etc aren't relevant for this purpose so I'm not interested in creating them. I guess I could read sys.columns and build a script from that, but is there a better way?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
