一、Oracle數據庫查看約束情況
1、約束情況
Select t.Owner,
t.Constraint_Name,
t.Constraint_Type,
t.Table_Name,
t.r_Owner,
t.r_Constraint_Name,
t.Delete_Rule,
t.Index_Owner,
t.Index_Name
From User_Constraints t
Where t.Status = 'ENABLED'
Order By t.Constraint_Type, t.Constraint_Name
Type Code |
Type Description |