Voici ses principaux champs :
| Nom du champ | Type du champ | Description du champ |
| constraint_name | VarChar | Nom de la contrainte. |
| constraint_type | VarChar | P, U ou R. |
| owner | VarChar | Nom du propriétaire de la table. |
| table_name | VarChar | Nom de la table. |
SELECT
b.owner,
'',
b.tablespace_name,
b.tablename,
a.constraint_name,
DECODE(a.constraint_type,
'U', 1,
0),
c.column_name,
c.position
FROM ALL_CONSTRAINTS a, ALL_TABLES b, ALL_CONS_COLUMNS c
WHERE
a.owner=b.owner
AND a.table_name=b.table_name
AND a.owner=c.owner
AND a.constraint_name=c.constraint_name
AND a.table_name=c.table_name
AND b.tablespace_name LIKE 'MonSchema%'
AND a.table_name LIKE 'MaTable%'
AND a.constraint_type IN ('P', 'U')
ORDER BY b._tablespace_name, b.table_name, a.constraint_name, c.position;