Oracle 数据库SQL语句查询oracle数据库表主键，查看oracle指定表的表结构实例演示

-- 查看表结构
select * from user_tab_columns where table_name = '表名';

-- 查看表主键
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 = '表名';