用户工具

站点工具


sql

SQL

PGSQL

删除所有的表

Bash
  1. DO $$ DECLARE
  2. r RECORD;
  3. BEGIN
  4. FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = current_schema()) LOOP
  5. EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.tablename) || ' CASCADE;';
  6. END LOOP;
  7. END $$;
/storage/data/pages/sql.txt · 最后更改: bestony

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki