select ‘drop table ‘||TABLE_NAME||’ cascade constraints;’ from USER_TABLES
where (NUM_ROWS=0 or NUM_ROWS is null ) and TABLE_NAME not like ‘ACT_%’ order by table_name;
删除数据库中空表的SQL
最新推荐文章于 2024-04-14 22:27:42 发布
select ‘drop table ‘||TABLE_NAME||’ cascade constraints;’ from USER_TABLES
where (NUM_ROWS=0 or NUM_ROWS is null ) and TABLE_NAME not like ‘ACT_%’ order by table_name;