Shulou(Shulou.com)06/01 Report--

1. PLSQL logs in to user An and opens a SQL Window window.

2. Build the command to delete all tables

Select 'drop table' | | table_name | | 'purge' from user_tables

Or

Select 'drop table' | | table_name | |'; 'from user_tables

Note: adding 'purge'' means permanent deletion is unrecoverable

3. Open a Command Window window and execute all the SQL copies built above.

Note: if there is a primary key association, continue to perform steps 2 and 3 until there is no result in the query 2.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.