How to Script a MS SQL Server Table - TechRepublic
General discussion
April 9, 2002 at 06:07 AM
geoff.walter

How to Script a MS SQL Server Table

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 want to create a SQL Server job to DROP & CREATE a table, but instead of ‘hard coding’ the TSQL code in a jobstep to create my table, I would prefer to generate the TSQL CREATE command 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