select dbms_metadata.get_ddl(‘TABLE’,’table_name’,’schema’) from dual;
INDEX:
select dbms_metadata.get_ddl(‘INDEX’,’index_name’,’schema’) from dual;CONSTRAINT:
select dbms_metadata.get_ddl(‘CONSTRAINT’,’table_name’,’schema’) from dual;
Advertisements
Leave a Reply