--主键 select column_name from user_ind_columns where INDEX_NAME in(select INDEX_NAME from user_indexes where uniqueness = 'UNIQUE') and table_name = 'aaa' --外键 select column_name from user_ind_columns where INDEX_NAME in (select INDEX_NAME from user_indexes where uniqueness = 'UNIQUE') and table_name <> 'aaa' and colunm_name in(select column_name user_col_comments where table_name='aaa')
dbms_metadata 得到建表语句 select dbms_metadata.get_ddl('TABLE', 'EMP', 'SCOTT') from dual;
pri** key 就是主建
foreign key就是外间
--主键
select column_name from user_ind_columns where INDEX_NAME in(select INDEX_NAME from user_indexes where uniqueness = 'UNIQUE') and table_name = 'aaa'
--外键
select column_name from user_ind_columns where INDEX_NAME in
(select INDEX_NAME from user_indexes where uniqueness = 'UNIQUE')
and table_name <> 'aaa' and colunm_name in(select column_name user_col_comments where table_name='aaa')
得到建表语句
select dbms_metadata.get_ddl('TABLE', 'EMP', 'SCOTT') from dual;