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.
