--- Erwin Ambrosch <ambre@ebutec.com> wrote:
> Hi,
>
> I have a such a table.
>
> CREATE TABLE int_article (
> name VARCHAR(12) UNIQUE
> headline TEXT,
> summary TEXT,
> main TEXT,
> footer TEXT,
> PRIMARY KEY (name)
> );
>
> Is the UNIQUE constraint neccessary, because if have
> specified the column
> name to be the primary key.
>
> Thanks in advance
> Erwin
No; but if you eliminate 'UNIQUE', you'll need to
replace it with 'NOT NULL'.
Andrew Gould
__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com