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?
LVL 9
sah18Asked:
Who is Participating?
 
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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.