PenWin wrote:

> 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".

I think you're going to have to grub around in the
RDB$RELATION_CONSTRAINTS table for the actual name of
the constraint.


Regards,


Ann