Subject | Droppping UNIQUE constraint |
---|---|
Author | PenWin |
Post date | 2006-12-01T20:22:16Z |
Hi!
Yet another question. Some time ago I set a table column to be unique:
ALTER TABLE tablename ADD UNIQUE(column)
Now I discover that I in fact can't have this column unique. How do I drop
the constraint? The documentation seems to suggest something like
ALTER TABLE tablename DROP CONSTRAINT UNIQUE(column)
But that results in invalid keyword "unique".
Pepak
Yet another question. Some time ago I set a table column to be unique:
ALTER TABLE tablename ADD UNIQUE(column)
Now I discover that I in fact can't have this column unique. How do I drop
the constraint? The documentation seems to suggest something like
ALTER TABLE tablename DROP CONSTRAINT UNIQUE(column)
But that results in invalid keyword "unique".
Pepak