Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy a table and its data

Status
Not open for further replies.

Katy44

Technical User
Dec 12, 2003
723
GB
I may be missing something obvious here, but is there a way to copy a table and all its data (possibly minus the constraints) to another database in one go?
I have so far been getting the create script, running it on the other db (on another server) then importing the data. I just wondered if there was a quicker way?
 
I've just realised that if you go to import data and don't create the table first, it creates it for you.
Yes, I was missing something obvious! :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top