Re: SQL*Plus - PK Question

One of the reasons I have done it is for clarity, not just for myself, but, for the developers I work(ed) with. This is especially helpful when they do a describe on the table.

HTH,
Pete's

"Sted Alana" <Sted_Alana_at_hotmail.com> wrote in message news:<3cc506ff_1_at_news.iprimus.com.au>...
> I have come across many examples in sql*plus with regards to using 'not
> nulls' in conjunction with primarys keys. This bothers me because from my
> reading when a primary key is defined for an attributes(s) of a table, it
> assumes that those values cannot contain null values, but yet i see this:
>
> create table Example
> (
> sid char(5) not null,
> ....
> constraint pk_sid primary key (sid)
> );
>
> why need to use not null when primary key implicitly imposes that contraint?
>
> Any help appreciated.
Received on Tue Apr 23 2002 - 07:15:31 CDT