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