使用下面语句从all_constraints视图中查看某表上的约束:
SELECT constraint_name, table_name, r_owner, r_constraint_name
FROM all_constraints
WHERE table_name = 'table_name' and owner = 'owner_name';
另一个视图ALL_CONS_COLUMNS也包括组成表上约束列的信息。
实验:通过关联关系找到表 constraint_name 关联关系 owner 数据库用户名
SELECT constraint_name, table_name, r_owner, r_constraint_name
FROM all_constraints a
WHERE a.owner = 'UFLOWDEV' and a.constraint_name = 'Reference_6'
SELECT constraint_name, table_name, r_owner, r_constraint_name
FROM all_constraints
WHERE table_name = 'table_name' and owner = 'owner_name';
另一个视图ALL_CONS_COLUMNS也包括组成表上约束列的信息。
实验:通过关联关系找到表 constraint_name 关联关系 owner 数据库用户名
SELECT constraint_name, table_name, r_owner, r_constraint_name
FROM all_constraints a
WHERE a.owner = 'UFLOWDEV' and a.constraint_name = 'Reference_6'