query for copying table

Hi,
I wanted to know a query in sql that would copy a whole table from one database to another database with both the structure and the content.
strangely, my college professor don't know the same.
I tried looking in the help menu in sql but it didn't helping me much.
Help me out...!! I have a deadline to meet. I really would appreciate it. thanxs. --vijay.You could use DTS (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_basic_71v7.asp), or the SELECT *
INTO newTable
FROM otherdatabase.owner.oldTablesyntax to copy your table from one database to another.

-PatP|||Books online is the first hand help you can get for any such syntax and information.|||Thank you very much. The query worked. Now i will get back to work and finish it off. I didn't understand about the DTS. but anyways the query was enuf.|||Refer to books online about DTS.