In Oracle, you can use the "select 'Drop table '||table_name||';' from all_tables where owner='User name to delete all tables';" statement to delete all tables under the specified user , the table name needs to be in uppercase letters
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
The syntax is:
select 'Drop table '||table_name||';' from all_tables where owner='要删除所有表的用户名(大写)';
The example is as follows:
Recommended tutorial: "Oracle Video Tutorial》
The above is the detailed content of How to delete all tables in oracle. For more information, please follow other related articles on the PHP Chinese website!