MS-SQL PK삭제 및 재 설정

   1:  -- PK 삭제

   2:  alter table DBNAME.dbo.TABLENAME

   3:  drop PK_TABLENAME

   4:  go

   5:   

   6:  select *

   7:  from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

   8:  where TABLE_NAME = 'TABLENAME'

   9:   

  10:  -- 컬럼 수정

  11:  alter table DBNAME.dbo.TABLENAME alter column COLUMN_NAME1 varchar(4) not null;

  12:   

  13:  -- PK 추가

  14:  alter table DBNAME.dbo.TABLENAME add constraint PK_TABLENAME primary key (

  15:      COLUMN_NAME2,

  16:      COLUMN_NAME3,

  17:      COLUMN_NAME4

  18:      );

  19:  go

  20:   

  21:  select *

  22:  from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

  23:  where TABLE_NAME = 'TABLENAME'