摘要:        
如何找数据库表的主键字段的名称? 
SELECT * FROM user_constraints WHERE CONSTRAINT_TYPE='P' and table_name='AAA';
select * from dba_cons_columns where CONSTRAINT_NAME='SYS_AAA';    阅读全文
posted @ 2008-05-20 13:48 Nuke'Blog 阅读(579) 评论(0) 推荐(0)
			
  | 
	|||
| 
			 
摘要:        
如何找数据库表的主键字段的名称? 
SELECT * FROM user_constraints WHERE CONSTRAINT_TYPE='P' and table_name='AAA';
select * from dba_cons_columns where CONSTRAINT_NAME='SYS_AAA';    阅读全文
 
posted @ 2008-05-20 13:48 Nuke'Blog 阅读(579) 评论(0) 推荐(0)  | 
	|||