How do I generate scripts for all tables with single stroke in SQL Server 2000?

Question

How do I generate scripts for all tables with a single stroke in SQL Server 2000?

score 42 · Answer 1 · answered Feb 25 '11 at 07:35

42

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.

answered Feb 25 '11 at 07:35

codingbadger

I guess it was just a race to see who could write out those steps quickest :-) – Damien_The_Unbeliever Feb 25 '11 at 07:35
@Damien - Yes it is one of those types of questions.... Fastest finger first! :) – codingbadger Feb 25 '11 at 07:37
thanks friends, its very useful – Ganesamoorthy Feb 25 '11 at 09:47

1 Answers1