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))BEGINDECLARE 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=<i>本文来源gaodai$ma#com搞$$代**码)网@</i>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))BEGINDECLARE 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;
?
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：MySQL 判断和删除目录和表外键
转载请注明原文链接：MySQL 判断和删除目录和表外键
