-- SQL script to drop all sequences from a specific schema
-- This script will be executed with a parameter for the schema name
-- Usage: psql -v schema_name="your_schema" -f SQL-Drop-Sequences.sql

SELECT 'DROP SEQUENCE IF EXISTS "' || schemaname || '"."' || sequencename || '" CASCADE;'
FROM pg_sequences
WHERE schemaname = :'schema_name'
\gexec
