if not( exists (SELECT * FROM syscolumns WHERE OBJECT_NAME(id) = 'ctpPracticeM' AND name = N'MasterID')) ALTER TABLE ctpPracticeM ADD MasterID varchar(12) NULL GO