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

[bonosa]

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

 

[bonosa]

I didnt see in the docs create table abc select * from db2.xyz but that what I did and it works...

thanks,
sb