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.
Originally Posted by nanou9999
Is it possible to create materialized views (as in Oracle) ?