mssql pk삭제/추가하기

 출처 : http://7day.tistory.com/272

-- PK 삭제
alter table DBNAME.dbo.TABLENAME
drop PK_TABLENAME
go

select *
from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where TABLE_NAME = 'TABLENAME'

-- 컬럼 수정
alter table DBNAME.dbo.TABLENAME 
	alter column COLUMN_NAME1 varchar(4) not null;

-- PK 추가
alter table DBNAME.dbo.TABLENAME add constraint PK_TABLENAME primary key (
	COLUMN_NAME2,
	COLUMN_NAME3,
	COLUMN_NAME4
	);
go

select *
from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where TABLE_NAME = 'TABLENAME'