drops.sql

DROP POLICY policy_name ON schema_name.table_name;
DROP POLICY policy_name ON table_name;

REVOKE DELETE ON TABLE schema_name.table_name FROM authenticated;
REVOKE DELETE ON TABLE table_name FROM authenticated;

DROP TABLE table_name;
DROP TABLE schema_name.table_name;

ALTER TABLE schema_name.table_name DROP COLUMN column_name;
ALTER TABLE "schema-name".table_name DROP COLUMN column_name;
ALTER TABLE "schema-name"."aa-bdd" DROP COLUMN "sdf-sdf";
ALTER TABLE "table-name" DROP COLUMN column_name;
ALTER TABLE table_name DROP COLUMN column_name;

DROP sequence if exists hsseq;
DROP sequence if exists "some-thing".hsseq;

ALTER TABLE schemaname.table_name RENAME column_name1 TO new_column_name1;
ALTER TABLE table_name RENAME column_name1 TO new_column_name1;

DROP TYPE test_type;
DROP TYPE schema_name.test_type;
DROP TYPE "schema-name".test_type;
DROP TYPE "schema-name"."test-type";
DROP TYPE IF EXISTS test_type_exists;
DROP TYPE IF EXISTS "aa-bb".test_type_exists;
drop type eitype cascade;

-- DROP AGGREGATE testagg1b(testdomain1);
DROP DOMAIN testdomain2b;
DROP DOMAIN schema_name.testdomain2b;
-- DROP OPERATOR !! (NONE, testdomain1);
DROP FUNCTION testfunc5b(a testdomain1);
DROP FUNCTION "my-schema".testfunc5b(a testdomain1);
DROP FUNCTION testfunc6b(b int);
DROP FUNCTION "my-schema".testfunc6b(b int);
DROP FUNCTION "my-schema"."test-func6b"(b int);
DROP FUNCTION testfunc7777;
DROP FUNCTION "my-schema".testfunc7777;

-- DROP CAST (testdomain1 AS testdomain3b);

DROP TRIGGER trigger_name ON table_name;
DROP TRIGGER IF EXISTS trigger_name ON table_name;

DROP TRIGGER trigger_name ON schema_name.table_name;
DROP TRIGGER IF EXISTS trigger_name ON schema_name.table_name;

DROP RULE rule_name ON table_name;
DROP RULE IF EXISTS rule_name ON table_name;

DROP RULE rule_name ON schema_name.table_name;
DROP RULE IF EXISTS rule_name ON schema_name.table_name;

DROP VIEW IF EXISTS test_view_exists;

DROP VIEW test_view_exists;

-- DROP USER tu2;
-- DROP USER IF EXISTS tu1, tu2;

DROP EXTENSION test_extension_exists;
DROP EXTENSION IF EXISTS test_extension_exists;

DROP FOREIGN DATA WRAPPER test_fdw_exists;
DROP FOREIGN DATA WRAPPER IF EXISTS test_fdw_exists;

DROP AGGREGATE IF EXISTS no_such_schema.foo(int);
DROP AGGREGATE IF EXISTS foo(no_such_type);
DROP AGGREGATE IF EXISTS foo(no_such_schema.no_such_type);

DROP CAST IF EXISTS (INTEGER AS no_such_type2);
DROP CAST IF EXISTS (no_such_type1 AS INTEGER);
DROP CAST IF EXISTS (INTEGER AS no_such_schema.bar);
DROP CAST IF EXISTS (no_such_schema.foo AS INTEGER);

DROP COLLATION IF EXISTS no_such_schema.foo;
DROP CONVERSION IF EXISTS no_such_schema.foo;
DROP DOMAIN IF EXISTS no_such_schema.foo;
DROP FOREIGN TABLE IF EXISTS no_such_schema.foo;

DROP INDEX IF EXISTS no_such_schema.foo;
DROP INDEX my_index;
DROP INDEX CONCURRENTLY my_index;
DROP INDEX IF EXISTS my_index;
DROP INDEX CONCURRENTLY IF EXISTS my_index;
DROP INDEX schema.my_index;
DROP INDEX CONCURRENTLY schema.my_index;
DROP INDEX CONCURRENTLY IF EXISTS schema.my_index;
DROP INDEX my_index CASCADE;
DROP INDEX CONCURRENTLY my_index CASCADE;
DROP INDEX CONCURRENTLY IF EXISTS my_index CASCADE;
DROP MATERIALIZED VIEW IF EXISTS no_such_schema.foo;

-- DROP OPERATOR IF EXISTS no_such_schema.+ (int, int);
-- DROP OPERATOR IF EXISTS + (no_such_type, no_such_type);
-- DROP OPERATOR IF EXISTS + (no_such_schema.no_such_type, no_such_schema.no_such_type);
-- DROP OPERATOR IF EXISTS # (NONE, no_such_schema.no_such_type);