Create a table from another table ?

Is it possible to create a table from another table ?
Is it possible to create materialized views (as in Oracle) ?Is it possible to create a table from another table ?Yes, there are many ways. the simplest is probably to use the DTS Import and Export Data wizard from the SQL Server 2000 group in your start menu. Use the same databases as the source and destination, and give the table a new name.

Note that there are many ways to accomplish this task, this is just the quick/easy/GUI way that jumps to mind.
Is it possible to create materialized views (as in Oracle) ?Certainly (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/IndexedViews.asp)!

-PatP|||Another simplest method is to use SELECT ... INTO <TABLE> FROM <TABLE>