Re: dups in table, need constraint clause

So you are saying:

create table event_vip (
vip_event_id number CONSTRAINT fk_vip_event_id REFERENCES event_root(event_id),
org_id number CONSTRAINT fk_org_id REFERENCES event_lvl(org_id), primary key (vip_event_id, org_id)
)

Comma before the "primary key" ?

Mike

Sybrand Bakker wrote:

> On Wed, 19 Mar 2003 16:32:15 -0600, Michael Hill
> <hillmw_at_ram.lmtas.lmco.com> wrote:
>
> >but can i include this constraint somewhere in the table creation sql?
>
> as last line before the closing parenthesis
>
> primary key ...
>
> )
>
> as defined in the sql reference manual
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Mar 19 2003 - 19:16:37 CST