Çå·ç»ÃÓ°µÄ²©¿Í

SELECT * FROM User_Tab_Columns WHERE table_name='±íÃû(×Öĸ´óд)'

²éѯij¸ö±íÖеÄ×Ö¶ÎÃû³Æ¡¢ÀàÐÍ¡¢¾«¶È¡¢³¤¶È¡¢ÊÇ·ñΪ¿Õ
select COLUMN_NAME,DATA_TYPE,DATA_PRECISION,DATA_SCALE,NULLABLE
from user_tab_columns
where table_name ='YourTableName'

²éѯij¸ö±íÖеÄÖ÷¼ü×Ö¶ÎÃû
select col.column_name
from user_constraints con,  user_cons_columns col
where con.constraint_name = col.constraint_name
and con.constraint_type='P'
and col.table_name = 'YourTableName'
²éѯij¸ö±íÖеÄÍâ¼ü×Ö¶ÎÃû³Æ¡¢ËùÒýÓñíÃû¡¢ËùÓ¦ÓÃ×Ö¶ÎÃû
select distinct(col.column_name),r.table_name,r.column_name
from
user_constraints con,
user_cons_columns col,
(select t2.table_name,t2.column_name,t1.r_constraint_name
 from user_constraints t1,user_cons_columns t2
 where t1.r_constraint_name=t2.constraint_name
 and t1.table_name='YourTableName'
 ) r
where con.constraint_name=col.constraint_name
and con.r_constraint_name=r.r_constraint_name
and con.table_name='YourTableName'