Generating MS SQLServer 7 Table Scripts - TechRepublic
General discussion
April 9, 2002 at 05:49 AM
geoff.walter

Generating MS SQLServer 7 Table Scripts

by geoff.walter . Updated 24 years, 2 months ago

Besides using MS SQL Server Enterprise Manager, does anyone have a method of scripting a Microsoft SQL Server table and it’s related indexes into TSQL code? I would like to automate the DROP & CREATE of a table, but instead of ‘hard coding’ the TSQL code in a jobstep to create my table, I would prefer to generate the TSQL code immediately prior to the DROP step, and then run that TSQL script to recreate my table after doing the DROP.

This discussion is locked

All Comments