PK생성,삭제

PK삭제

ALTER TABLE [table_name] DROP CONSTRAINT [pk_name] CASCADE;

DROP INDEX [pk_name];

ALTER TABLE [table_name] DROP PRIMARY KEY;

 

PK생성

ALTER TABLE [table_name] ADD CONSTRAINT [pk_name] PRIMARY KEY([컬럼1],[컬럼2],....);