COLUMN TABLE FORMAT A9
COLUMN COLONNE FORMAT A9
COLUMN CONTRAINTE FORMAT A12
COLUMN "TABLE REF" FORMAT A9
COLUMN "COL REF" FORMAT A9
COLUMN "TEXTE CONTRAINTE" FORMAT A20

PROMPT 'Contraintes de type CLE PRIMAIRE ou UNIQUE :'
SELECT T.TABLE_NAME "TABLE",COLUMN_NAME "COLONNE",
       T.CONSTRAINT_NAME CONTRAINTE, T.CONSTRAINT_TYPE "TYPE"
FROM USER_CONSTRAINTS T, USER_CONS_COLUMNS C
WHERE T.CONSTRAINT_NAME = C.CONSTRAINT_NAME
  AND CONSTRAINT_TYPE  IN ('U', 'P')
/
PROMPT 'Contraintes de type REFERENCES :'
SELECT T.TABLE_NAME "TABLE", C.COLUMN_NAME "COLONNE", 
       T.CONSTRAINT_NAME CONTRAINTE,
       DELETE_RULE,
       REF.TABLE_NAME "TABLE REF", REF.COLUMN_NAME "COL REF",
        'REFERENCE' "TYPE"
FROM USER_CONSTRAINTS T, USER_CONS_COLUMNS C, USER_CONS_COLUMNS REF
WHERE T.CONSTRAINT_NAME = C.CONSTRAINT_NAME
  AND REF.CONSTRAINT_NAME = T.R_CONSTRAINT_NAME
  AND CONSTRAINT_TYPE  = 'R'
/
PROMPT 'Contraintes de type CHECK ou NOT NULL :'
SELECT TABLE_NAME "TABLE", CONSTRAINT_NAME CONTRAINTE,
       SEARCH_CONDITION "TEXTE CONTRAINTE", CONSTRAINT_TYPE "TYPE"
FROM USER_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'C'
/