ALTER TABLE problem

#1

The following ALTER TABLE statement in ISQL genterates a syntax error
(syntax error near UNIQUE). What am I doing wrong?

ALTER TABLE dba.po_line MODIFY record_id UNIQUE

SQLA 8.0.3

TIA
Mike

#2

I think it should be:

ALTER TABLE dba.po_line ADD UNIQUE (record_id)

*Untested*

Mike Marston wrote:

Quote:

The following ALTER TABLE statement in ISQL genterates a syntax error
(syntax error near UNIQUE). What am I doing wrong?

ALTER TABLE dba.po_line MODIFY record_id UNIQUE

SQLA 8.0.3

TIA
Mike

#3

Kory,
That did it. Thanks!

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

Quote:

I think it should be:

ALTER TABLE dba.po_line ADD UNIQUE (record_id)

*Untested*

Mike Marston wrote:
The following ALTER TABLE statement in ISQL genterates a syntax error
(syntax error near UNIQUE). What am I doing wrong?

ALTER TABLE dba.po_line MODIFY record_id UNIQUE

SQLA 8.0.3

TIA
Mike

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ALTER TABLE problem

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

ALTER TABLE problem - 08-17-2009 , 01:36 PM

Re: ALTER TABLE problem - 08-17-2009 , 01:58 PM

Re: ALTER TABLE problem - 08-17-2009 , 02:52 PM