What if we change your code to:

CREATE TABLE Code (

CodeID int IDENTITY(1,1)

, CodeType int

, Description varchar(255))

ALTER TABLE Code ADD CONSTRAINT PK_Code PRIMARY KEY (CodeID)

CREATE...