oracle查看表结构和约束

查看表结构

select * from user_tab_columns where table_name='TEL_SYS_COVERCONFINE';

查看表中字段约束

select a.constraint_name,  a.column_name
from user_cons_columns a, user_constraints b
where a.constraint_name = b.constraint_name
and b.constraint_type = 'P'
and a.table_name = 'TEL_SYS_COVERCONFINE';