IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id 
              WHERE SYSCOLUMNS.NAME = 'DIGERPERSONEL' AND SYSOBJECTS.name = 'TSAGLIKP')
ALTER TABLE [TSAGLIKP] ADD DIGERPERSONEL bit NOT NULL CONSTRAINT DF_TSAGLIKP_DIGERPERSONEL DEFAULT 0

GO