if not exists (select * from sys.syscolumns where name = 'Departments' AND id = object_id(N'dbo.UserInfo'))
   and exists (select * from sys.tables where object_id = object_id(N'dbo.UserInfo'))
    alter table dbo.UserInfo
    add Departments nvarchar(256) null
        ,SecurityKey nvarchar(max) null
        ,AccountSettings nvarchar(max) null
        ,CreatedByLoggedUserName nvarchar(256) null
        ,CreatedByUserName nvarchar(256) null
        ,ModifiedDate datetime null
        ,ModifiedUserName nvarchar(256) null
        ,ModifiedLoggedUserName nvarchar(256) null
        ,Data nvarchar(max) null