用scott用户登录:
conn scott/tiger
1. 查看登录用户表的约束
SELECT constraint_name, constraint_type, status, deferrable, deferred
FROM user_constraints
2. 查看所有用户表的约束
SELECT constraint_name, constraint_type, status, deferrable, deferred
FROM all_constraints
3. 查看登录用户约束名称和约束列
SELECT constraint_name, column_name
FROM user_cons_columns
4. 查看所有用户约束名称和约束列
SELECT constraint_name, column_name
FROM all_cons_columns
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7865774/viewspace-591105/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7865774/viewspace-591105/