Help Center/ Data Warehouse Service / More Documents/ Tool Guide (Kuala Lumpur Region)/ DSC/ Migrating MySQL Syntax/ Table (Optional Parameters and Operations)/ FOREIGN_KEY_CHECKS
Updated on 2025-10-14 GMT+08:00
View PDF
Share

FOREIGN_KEY_CHECKS

FOREIGN_KEY_CHECKS indicates the foreign key constraints in MySQL. DWS does not support table definition modification using this attribute. DSC will delete the attribute during migration.

Input

1
2
3
4
5
6
 
SET foreign_key_checks = 0;
CREATE TABLE mall_order_dc (
    id bigint NOT NULL AUTO_INCREMENT,
    order_id varchar(50) NOT NULL,
    key order_id(order_id)
);

Output

1
2
3
4
5
 
CREATE TABLE "public"."mall_order_dc" (
  "id" BIGSERIAL NOT NULL,
  "order_id" VARCHAR(200) NOT NULL
) WITH (ORIENTATION = ROW, COMPRESSION = NO) NOCOMPRESS DISTRIBUTE BY HASH ("id");
CREATE INDEX "order_id" ON "public"."mall_order_dc" USING BTREE ("order_id");