The rules and restrictions for the SHOW CONSTRAINT statement are as follows.
- You must have either the CONSTRAINT DEFINITION privilege or the CONSTRAINT ASSIGNMENT privilege to execute this statement.
- The constraint you specify must currently exist in your system.