How to delete all tables in oracle

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.

How to delete all tables in oracle

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!