---获取表的定义结构sql
select dbms_metadata.get_ddl('TABLE', 'TABLE_NAME', 'TABLE_OWNER') from dual ;
---删除表同时删除关联的constraints
Drop table cascade constraints ;
---获取表的定义结构sql
select dbms_metadata.get_ddl('TABLE', 'TABLE_NAME', 'TABLE_OWNER') from dual ;
---删除表同时删除关联的constraints
Drop table cascade constraints ;