Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Cergy
    Posts
    65

    Question Unanswered: 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) ?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by nanou9999
    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.
    Quote Originally Posted by nanou9999
    Is it possible to create materialized views (as in Oracle) ?
    Certainly!

    -PatP

  3. #3
    Join Date
    Sep 2005
    Posts
    28

    Unhappy

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

  4. #4
    Join Date
    May 2010
    Posts
    1

    Wink create new table from existing table

    Hi,

    you can use the following query
    Select * into TB_CUST_ AGENT Fom TB_AGENT

    Regards, Alpesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •