*MySQLのALTER文 [#d3e4bf4d] ***INDEXの追加 [#r4d4102f] ALTER TABLE sample_table ADD INDEX INDEX_SAMPLE_SAMPLE_NUMBER (sample_number); ***FOREIGN KEYの追加 [#c1d38563] ALTER TABLE sample_table CONSTRAINT FK_SAMPLE_SAMPLE_CATEGORY_ID FOREIGN KEY (sample_category_id) REFERENCES sample_category_table(sample_category_id); ***UNIQUEの追加 [#dcfeaf2f] ALTER TABLE sample_table ADD UNIQUE (sample_id); ***COLUMNの追加 [#ba457be3] ALTER TABLE sample_table ADD COLUMN del_flag INTEGER; ***NULLを設定 [#q0dadd6c] ALTER TABLE sample_table MODIFY del_flag INTEGER NOT NULL; ***NULLを解除 [#a41bfa7f] ALTER TABLE sample_table MODIFY del_flag INTEGER; ***DEFAULTを設定 [#rb73732d] ALTER TABLE sample_table ALTER COLUMN del_flag SET DEFAULT 0; ***DEFAULTを解除 [#xee77ff1] ALTER TABLE sample_table ALTER COLUMN del_flag DROP DEFAULT; ***COLUMNの修正 [#ae9a6be2] ALTER TABLE sample CHANGE sample_name sample_name VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; ALTER TABLE sample CHANGE sample_name sample_name VARCHAR( 6 ) NULL DEFAULT NULL;