Hi all...
Getting back into SQL Anywhere after being away awhile, so please forgive
the newbie-ish question.
I'm wanting to add a unique contraint to a column...
I've found examples using "CREATE TABLE" syntax, but for some reason, I'm
having trouble finding syntax for adding column uniqueness using "ALTER
TABLE syntax.
Any ideas?

Thanks...


__________ Information from ESET NOD32 Antivirus, version of virus signature database 4710 (20091222) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

This should add a unique constraint to a column:

ALTER TABLE table_name ADD UNIQUE (column_name);


SQL Antwhere wrote:

thx Kory ... column in question had to be set for "no nulls" first ( of
course ) but your syntax worked great ...I appreciate the help.

"Kory Hodgson (Sybase iAnywhere)" <khodgson (AT) A_SPAM_FREE_sybase (DOT) com> wrote in
message news:4b3124e3$1 (AT) forums-1-dub (DOT) ..

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4710 (20091222) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com