Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT 'alter table "' || tc.table_name || '" drop constraint "' || tc.constraint_name || '";' FROM information_schema.table_constraints AS tc JOIN information_schema.key_column_usage AS kcu ON tc.constraint_name = kcu.constraint_name JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.constraint_name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement