SELECT 'ALTER TABLE ' || TABLE_NAME || ' DROP CONSTRAINT ' || CONSTRAINT_NAME || ';' FROM USER_CONS_COLUMNS WHERE (TABLE_NAME LIKE 'xxx%' OR TABLE_NAME LIKE 'xxx%' OR TABLE_NAME LIKE 'xxx%') AND CONSTRAINT_NAME LIKE 'F%';
SELECT 'ALTER TABLE ' || TABLE_NAME || ' DROP CONSTRAINT ' || CONSTRAINT_NAME || ';' FROM USER_CONS_COLUMNS WHERE (TABLE_NAME LIKE 'xxx%' OR TABLE_NAME LIKE 'xxx%' OR TABLE_NAME LIKE 'xxx%') AND CONSTRAINT_NAME LIKE 'F%';