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.
