Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Create a new table based on existing table

    Dear All,
    I would like to create a new tabe based on an already existing table in informix 9.4 database. I don't want to have the records in the new table from the source table. I tried with the query
    "Create table A as select * from B" and it ends up with Syntax error.

    Could anyone please help me out in the correct sysntax for the above query ?

    Thanks.

    Rajac.

  2. #2
    Join Date
    Mar 2003
    Posts
    7

    Re: Create a new table based on existing table

    Hi,
    try 'dbschema -d <database> -t <table>'(command line unix). This shows the create statement without storage option.
    regards,
    Chris

Posting Permissions

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