//PRIMARY KEY 추가 alter table menu_caterory add primary key(idx); alter table "현재 테이블명" add primary key("컬럼명"); /FOREIGN KEY 추가 alter table category_sub add foreign key(category_main_idx) references category_main(idx); alter table "테이블명" add foreign key("컬럼명") references "참조할 테이블명"(참조할 컬럼명);