Re: Syntax Question - CREATE TABLE testtable OF testtype;

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 27 Oct 2002 19:04:43 +0100
Message-ID: <jkaorukgbv5v7d579267hjpa89al9n02kg@4ax.com>

On 27 Oct 2002 04:39:31 -0800, bbulsara23_at_hotmail.com (barry) wrote:

>CREATE OR REPLACE TYPE testtype AS OBJECT
>(
> id NUMBER(4),
> description VARCHAR2(10)
>);
>/
>
>CREATE TABLE testtable OF testtype;
>
>What is the syntax to 'CREATE TABLE testtable' such that 'id' is the
>primary key. I would like to enforce the primary key constraint in the
>'CREATE TABLE' statement but alternatively would be happy with
>enforcing the constraint afterwards in an 'ALTER' type construct.
>
>Can this be done?
>
>Thank you in advance
>Barry

The sql reference manual is online at http://tahiti.oracle.com

Please don't waste bandwith and people's time.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Oct 27 2002 - 12:04:43 CST