Subject | check if a table (unique) constraint is defined |
---|---|
Author | cornel rebegea |
Post date | 2010-06-13T14:18:06Z |
Hi,
Is there a way to check if a unique contraint is defined on a table?
This is the way I defined it
ALTER TABLE BON_ANTET ADD CONSTRAINT UNQ_BON_ANTET UNIQUE (BON_ID);
I need to a way to know if the constraint exists, and if not then just create it.
Thanks a million,
Cornel Rebegea.
[Non-text portions of this message have been removed]
Is there a way to check if a unique contraint is defined on a table?
This is the way I defined it
ALTER TABLE BON_ANTET ADD CONSTRAINT UNQ_BON_ANTET UNIQUE (BON_ID);
I need to a way to know if the constraint exists, and if not then just create it.
Thanks a million,
Cornel Rebegea.
[Non-text portions of this message have been removed]