Scripting Tables

Walden · June 5th, 2003, 05:45 AM

I am running SQL Server 2000 and I have over 800 tables & I want to scripts them all into one file. How can I go about this? Can anyone help me out? I look forward to hearing from you.

Regards,

CarlWalden

Jeff Mason · June 5th, 2003, 05:52 AM

Use Enterprise Manager.

Navigate to the database on your server, expand it, click tables. Select any table and right click, select All Tasks, Generate SQL Script. Click Show All, then check All Tables, then on the Options tab, select Create One File. You should probably check the Script Indexes and Script Primary keys in the Table Scripting Options sections on this tab as well.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Walden · June 5th, 2003, 06:02 AM

Jeff,

Thanks for your prompt reply I have done that before I posted it on the forum but it was taken over an hour and I cannot wait for that long, therefore I was thinking maybe there might be any other way to go about it. Thanks anyway.

Regards,

Quote:

quote:Originally posted by JeffMason
Use Enterprise Manager.

Navigate to the database on your server, expand it, click tables. Select any table and right click, select All Tasks, Generate SQL Script. Click Show All, then check All Tables, then on the Options tab, select Create One File. You should probably check the Script Indexes and Script Primary keys in the Table Scripting Options sections on this tab as well.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

CarlWalden