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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to duplicate a table from one database into another, different nam

Status
Not open for further replies.

bonosa

Programmer
May 19, 2004
76
US
I need the names of the tables to be different, but I want to create an identically structured table in my database patterned after a table in another database. I cant really create it and populate it with select * since I dont know the fields in the other in advance.
Thanks,
sb
 
I didnt see in the docs create table abc select * from db2.xyz but that what I did and it works...

thanks,
sb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top