how do i generate scripts for all tables with sing

Question

how do i generate scripts for all tables with single stroke in sql server 2000.

Answer 1

You can't do this with one click of a button.

You have to:

• Right click Database
• Select All Tasks > Generate SQL Scripts
• Click Show All
• Check All Tables
• Click the Formatting tab. Select the options you require
• Click the Options tab. You may want to script out the Indexes, Full-Text Indexes, Triggers, Primary & Foreign Keys.
• Then choose whether you want it all in one file or one file per object.