Discussion Locked

Generating MS SQLServer 7 Table Scripts

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

1 reply

This discussion is closed to new replies.