How to create scripts for all tables with one stroke in sql server 2000

Question

how can I generate scripts for all single-stroke tables in SQL Server 2000.

Answer 1

You cannot do this with the click of a button.

You should:

• Right click database
• Select All Tasks> Generate SQL Scripts
• Click Show All
• Check all tables
• Click the "Formatting" tab. Select the options you want.
• Click the Options tab. You might want a script of indexes, full-text indexes, triggers, primary and foreign keys.
• Then choose whether you want everything in one file or one file for each object.