copy a table skeleton

Z

zMaestro

Perch
How can I copy a table skeleton? I have a table in MsSQL I want to create another one (an image from it) but without any data, How can this be done?
 
If you have SQL Server Enterprise Manager you can do the following:

  1. Right click on the database
  2. Then "All Tasks" followed by "Generate SQL Script..."
  3. Click on the "Show All" button
  4. Select the "Script all objects" checkbox
  5. There are further options in the Formatting and Options tabs with allow you to generate further details.
 
Sorry, I misread that. Copying a table is actually simple in Enterprise manager. Find your table in the database, right click on it, select copy, then you can paste it into anything like notepad or query analyzer.
 
You must log in or register to reply here.
Back
Top