---保留表,只删除数据:
truncate table mytable;
delete from student where 1 = 1 ;
---删除表本身:
drop table mytable;
---永久性删除 恢复不了:
drop table mytable purge;
oracle删除整张表数据
最新推荐文章于 2024-01-06 14:37:29 发布
---保留表,只删除数据:
truncate table mytable;
delete from student where 1 = 1 ;
---删除表本身:
drop table mytable;
---永久性删除 恢复不了:
drop table mytable purge;