select object_name,object_type,status from user_objects;
第2个回答 2011-03-23
select a.constraint_name,a.table_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 b.table_name='你的表名';