求推荐将含ALTER的SQL转为内嵌约束的CREATE语句的在线工具
寻找可将含ALTER的SQL转换为整合约束的CREATE语句的在线工具?
我从phpMyAdmin导出了包含CREATE TABLE和ALTER TABLE语句的SQL,这些ALTER语句用于添加主键、索引、外键,具体内容如下:
CREATE TABLE 'table_1'( 'id' INT UNSIGNED NOT NULL AUTO_INCREMENT, 'name' TEXT NOT NULL ); ALTER TABLE 'table_1' ADD PRIMARY KEY 'table_1_id_primary'('id'); CREATE TABLE 'table_2'( 'id' INT UNSIGNED NOT NULL AUTO_INCREMENT, 'table_1' INT NOT NULL, 'name' TEXT NOT NULL ); ALTER TABLE 'table_2' ADD PRIMARY KEY 'table_2_id_primary'('id'); ALTER TABLE 'table_2' ADD INDEX 'table_2_table_1_index'('table_1'); ALTER TABLE 'table_2' ADD CONSTRAINT 'table_2_table_1_foreign' FOREIGN KEY('table_1') REFERENCES 'table_1'('id');
但我需要将这份SQL导入到DrawSQL中,而DrawSQL只能解析CREATE语句,会忽略ALTER语句。因此我需要把这些ALTER语句中的主键、外键、索引整合到对应的CREATE TABLE语句内,转换后的示例如下:
CREATE TABLE `table_1`( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` TEXT NOT NULL ); CREATE TABLE `table_2`( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `table_1` INT NOT NULL, `name` TEXT NOT NULL, FOREIGN KEY (table_1) REFERENCES table_1(id) );
请问是否存在可完成该转换的在线工具?提前致谢。
内容的提问来源于stack exchange,提问作者wael razouk
相关产品推荐
相关产品推荐

