摘要: --得到数据库的所有者名称SELECT distinct RDB$OWNER_NAME AS DATABASE_OWNERFROM RDB$RELATIONSWHERE (RDB$SYSTEM_FLAG = 1);--根据表名得到表的主键SELECT RC.RDB$CONSTRAINT_NAME AS CONSTRAINT_NAME, I.RDB$RELATION_NAME AS TABLE_NAME, S.RDB$FIELD_NAME AS COLUMN_NAMEFROM RDB$RELATION_CONSTRAINTS RC LEFT JOIN RDB$INDICES I ON (I.RD 阅读全文
posted @ 2011-05-31 21:03 fyen 阅读(3001) 评论(0) 推荐(0) 编辑