摘要:
如何找数据库表的主键字段的名称?
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 阅读(582) 评论(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 阅读(582) 评论(0) 推荐(0) |
|||