Fishbowl
Tables
(current)
Columns
Constraints
Orphan Tables
Routines
DropForeignKeysFromTable
Parameters
Name
Type
Mode
param_table_name
varchar(255)
IN
Definition
begin declare done int default FALSE; declare dropCommand varchar(255); declare dropCur cursor for select concat('alter table ',table_name,' DROP FOREIGN KEY ',constraint_name, ';') from information_schema.table_constraints where constraint_type='FOREIGN KEY' and table_name = param_table_name; declare continue handler for not found set done = true; open dropCur; read_loop: loop fetch dropCur into dropCommand; if done then leave read_loop; end if; set @sdropCommand = dropCommand; prepare dropClientUpdateKeyStmt from @sdropCommand; execute dropClientUpdateKeyStmt; deallocate prepare dropClientUpdateKeyStmt; end loop; close dropCur; end