• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1110
  • Last Modified:

SQL SErver 2000: Enterprise Manager how to make copy of existing table or view?

In Enterprise Manager, is there an easy way to copy an existing table or view?
0
sah18
Asked:
sah18
  • 3
  • 2
2 Solutions
 
curtis591Commented:
You right click and go to All Tasks and you can use the import wizard.

or

You can right click on an object -> All Tasks -> Generate SQL script will give you the SQL to create a blank version of the object.
0
 
mcmonapCommented:
>> You can right click on an object -> All Tasks -> Generate SQL script will give you the SQL to create a blank version of the object.

FYI you can also get this by right clicking and selecting copy on the table in enterprise manager - the code will be on the clipboard to paste where ever you want (QA)
0
 
sah18Author Commented:
Thanks very much!  Also (dumb question), but is there any mechanism for running sql script from right within enterprise manager, or is sql query analyzer the only option?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
sah18Author Commented:
ps:  i had wondered what the "copy" option did, since there was no paste option!
0
 
mcmonapCommented:
Hi sah18,

You can run some sql _statements_ in enterprise manager but not scripts or batches, I would stick with QA - enterprise manager is not really the place to be running script.
0
 
sah18Author Commented:
thanks to both of you for your help!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now