Results 1 to 5 of 5

Thread: Sql Querry Help

  1. #1
    Join Date
    May 2002
    Location
    Indai
    Posts
    11

    Unanswered: Sql Querry Help

    hi all ,
    what is the querry for creating a table from an existing table.
    (In oracle
    Create table table1
    as select * from table2)

    I am looking for SQL server querry for this

    Please help out

  2. #2
    Join Date
    Feb 2002
    Posts
    6
    Try

    select *
    into newtable
    from table1

    Cheers,
    Harry

  3. #3
    Join Date
    May 2002
    Location
    Shanghai,China
    Posts
    4

    a better one

    if U dont't want any data ,pls choose my post
    select * into destin_table
    from source_table where 1=0

  4. #4
    Join Date
    May 2002
    Location
    Indai
    Posts
    11
    Thank u very much

  5. #5
    Join Date
    May 2002
    Location
    Montréal, Canada
    Posts
    28
    jh.mei is right, just take care of your keys, it doesn't recreate them.
    Data Climber

Posting Permissions

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