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

sql-server sql-server-2000
Ganesamoorthy picture Ganesamoorthy · Feb 25, 2011 · Viewed 19.4k times · Source

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

Answer

codingbadger picture codingbadger · Feb 25, 2011

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.

Related questions

Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Check if table exists in SQL Server

I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL Statements. When you Google for the answer, you get so many different answers. Is there an official/backward …

Read More
How to Join to first row

I'll use a concrete, but hypothetical, example. Each Order normally has only one line item: Orders: OrderGUID OrderNumber ========= ============ {FFB2...} STL-7442-1 {3EC6...} MPT-9931-8A LineItems: LineItemGUID Order ID Quantity Description ============ ======== ======== ================================= {098FBE3...} 1 7 prefabulated amulite {1609B09...} 2 32 spurving bearing But occasionally there …

Read More