Adding Constraints
From: Bob Swerdlow <swerdlow_at_maine.rr.com>
Date: Mon, 11 Mar 2002 19:09:57 GMT
Message-ID: <9i7j8.6674$26.619241_at_typhoon.maine.rr.com>
Date: Mon, 11 Mar 2002 19:09:57 GMT
Message-ID: <9i7j8.6674$26.619241_at_typhoon.maine.rr.com>
I cannot figure out how to add a constraint to an existing table.
For example, I have a table with an "id" field that should have been created
as the primary key but was not. The documentation seems to indicate that I
can do:
ALTER TABLE MyTable MODIFY(id INTEGER PRIMARY KEY);
but this results in:
ERROR at line 1:
-- Bob Swerdlow Chief Operating Officer Transpose, LLC rswerdlow_at_transpose.comReceived on Mon Mar 11 2002 - 20:09:57 CET