mysql删除表 有约束

-- 查看表的外键约束
SHOW CREATE TABLE your_table_name;

-- 删除外键约束
ALTER TABLE your_table_name DROP FOREIGN KEY constraint_name;

DROP TABLE your_table_name;

SHOW CREATE TABLE orders;

CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `order_date` date NOT NULL,
  PRIMARY KEY (`order_id`),
  KEY `fk_customer_id` (`customer_id`),
  CONSTRAINT `fk_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE orders DROP FOREIGN KEY fk_customer_id;

DROP TABLE orders;