oracle 一个表的所有约束以及详细信息

ORACLE

表的所有约束以及详细信息

表名，列名，约束名，约束类型，check定义的约束，外键引用的表，外键引用的列名

COLUMN TABLE FOR a15 
COLUMN col FOR a15 
COLUMN cons FOR a30 
COLUMN TYPE FOR a2 
COLUMN ck FOR a30 
COLUMN fkTable FOR a30 
COLUMN fkColumn FOR a30 
SELECT
uc.table_name AS "table",
ucc.column_name AS "col",
uc.constraint_name AS "cons",
uc.constraint_type AS "type",
uc.search_condition AS "ck",
ucc2.table_name AS "fkTable",
ucc2.column_name AS "fkColumn" 
FROM
	user_constraints uc,
	user_cons_columns ucc,
	user_cons_columns ucc2 
WHERE
	uc.constraint_name = ucc.constraint_name ( + ) 
	AND uc.r_constraint_name = ucc2.constraint_name ( + ) 
	AND uc.table_name = 'STUDENT';