
update edfi.StudentAcademicRecordAcademicHonor
set HonorDescription = '' where HonorDescription is null;
go

 alter table edfi.StudentAcademicRecordAcademicHonor 
 alter column HonorDescription nvarchar(80) not null;

go

alter table edfi.StudentAcademicRecordAcademicHonor drop 
CONSTRAINT [PK_StudentAcademicRecordAcademicHonor] ;
go



alter table edfi.StudentAcademicRecordAcademicHonor add CONSTRAINT [PK_StudentAcademicRecordAcademicHonor] PRIMARY KEY CLUSTERED 
(
	[AcademicHonorCategoryTypeId] ASC,
	[StudentUSI] ASC,
	[SchoolYear] ASC,
	[HonorDescription] ASC);
go
