Web Development

General discussion


Generating MS SQLServer 7 Table Scripts

By geoff.walter ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums