删除表
select 'drop table '|| table_name || ';' from user_tables order by table_name
删除序列
select 'DROP SEQUENCE ' || SEQUENCE_NAME || ';' from dba_sequences where sequence_owner='EBSNEW';
导出删除表和序列的语句
最新推荐文章于 2024-09-07 21:42:26 发布
删除表
select 'drop table '|| table_name || ';' from user_tables order by table_name
删除序列
select 'DROP SEQUENCE ' || SEQUENCE_NAME || ';' from dba_sequences where sequence_owner='EBSNEW';