IF NOT EXISTS (SELECT * FROM SYS.SYSCOLUMNS WHERE ID = OBJECT_ID(N'ASMS_MODEL', N'U') AND NAME = 'instructions') BEGIN ALTER TABLE ASMS_MODEL ADD instructions VARCHAR(MAX) NULL; END; GO