Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    4

    Unanswered: Create table in Sybase

    Hi,

    I want to create a copy of table test with data in Sybase.. What command can i use for it. In oracle the following command works but in Sybase it gives error.

    create table test as select * from test;

    Please give me the command for the same.

    Regards
    Pulkit

  2. #2
    Join Date
    Feb 2004
    Location
    UK
    Posts
    43
    U can use the below syntax

    select * into new_tble_name from existing_table_name

Posting Permissions

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