It is quite simple. Don't do this in the same batch.

IF OBJECT_ID(N'dbo.mtzcus_2014_CoreMenuReportCriteria', N'U') IS NOT NULL

DROP TABLE dbo.mtzcus_2014_CoreMenuReportCriteria;

CREATE TABLE dbo.mtzcus_2014_CoreMenuReportCriteria

(

MeasureType VARCHAR(20) NOT NULL

,MeasureOrder TINYINT NOT NULL

,ObjectiveNumber VARCHAR(3) NOT NULL

,ObjectiveName VARCHAR(100)

,CriteriaCertificationNumber VARCHAR(50)

,ExclusionDescription VARCHAR(100)

,Threshold2014Stage2 DECIMAL(3, 0)

,Threshold2014Stage1 DECIMAL(3, 0)

,CONSTRAINT mtzcus_2014_CoreMenuReportCriteria_PK PRIMARY KEY CLUSTERED

( MeasureType, MeasureOrder, ObjectiveNumber )

);