mysql 判断和删除索引和表外键 ---- procedure of delete index--drop procedure if exists del_idx;create procedure del_idx(in p_table_name varchar(200), in p_idx_name varchar(200))begindeclare st varchar(250); set @st=concat(' drop index ', p_i
mysql 判断和删除索引和表外键-- -- procedure of delete index -- drop procedure if exists del_idx; create procedure del_idx(in p_table_name varchar(200), in p_idx_name varchar(200)) begin declare st varchar(250); set @st=concat(' drop index ', p_idx_name, ' on ', p_table_name); select count(*) into @cnt from information_schema.statistics where table_name=p_table_name and index_name=p_idx_name; if @cnt >0 then prepare stmt from @st; execute stmt; end if; end; call del_idx('t_name, 'idx_name'); drop procedure if exists del_idx; -- -- procedure of delete fk -- drop procedure if exists del_fk; create procedure del_fk(in p_table_name varchar(200), in f_k_name varchar(200)) begin declare st varchar(250); set @st=concat(' alter table ', p_table_name, ' drop foreign key ', f_k_name); select count(*) into @cnt from information_schema.key_column_usage where table_name=p_table_name and constraint_name=f_k_name; if @cnt >0 then prepare stmt from @st; execute stmt; end if; end; call del_fk('t_nam, 'fk_name); drop procedure if exists del_fk;.syntaxhighlighter{padding-top:20px;padding-bottom:20px;}
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！