Re: Create table, pk constraint, AS SELECT, Index Org tables

Hi Yosi -

    When using the CREATE ... AS SELECT ..., - you cannot specify a datatype for a column, but should be able to define integrity constraints. This will be in the SQL Reference Guide under the CREATE TABLE syntax diagram.

   Regards,
    Lisa

                Lisa West Hudd
                 e-DBA Limited
                 www.e-dba.net

Leading Database Services Into the Next Millennium

On Wed, 03 Nov 1999 10:10:08 -0500, Yosi Greenfield <ygreenfield_at_compuserve.com> wrote:

>Wise Colleagues,
>
>Is it possible to declare, at table creation time, a PK constraint on a
>table created using an AS SELECT clause?
>
>Normally, that shouldn't be an issue, you can create the table an then
>alter it to add the PK.
>
>However for index organized tables, you have to create the PK constraint
>at table creation. Does this mean that for IOTables you can't use the AS
>SELECT clause?
>
>Thanks,
>
>Yosi
>
>
>
>create an index organized table using an AS SELECT clause?
>
>To create an IOT, you have to declare a PK in the creation, and you need
>an ORGANIZATION INDEX clause. No matter how I
Received on Wed Nov 03 1999 - 10:32:30 CST