annejohnson

-- Temporarily change delimiter to $$
DELIMITER $$
-- Drop procedure if it exists
DROP PROCEDURE IF EXISTS drop_pk_if_exists $$
-- Begin create procedure
CREATE PROCEDURE drop_pk_if_exists () BEGIN
  -- If my_table has a primary key
  IF EXISTS(select * from `information_schema`.`table_constraints`
              where `constraint_schema` = database()
              and `constraint_type` = "PRIMARY KEY"