IF NOT EXISTS(SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[KUNDEN]') AND name = 'CSAPP_DRIVECHEK_RESULT')
alter table kunden add CSAPP_DRIVECHEK_RESULT varchar(255) null
IF NOT EXISTS(SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[KUNDEN]') AND name = 'CSAPP_DRIVECHECK_STATUS')
alter table kunden add CSAPP_DRIVECHECK_STATUS varchar(255) null
IF NOT EXISTS(SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[KUNDEN]') AND name = 'CSAPP_DRIVECHECK_RESULT_TEXT')
alter table kunden add CSAPP_DRIVECHECK_RESULT_TEXT varchar(255)

IF EXISTS(SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[KUNDEN]') AND name = 'CSAPP_KUNDENCODE')
alter table kunden alter column CSAPP_KUNDENCODE varchar(255)
ELSE
alter table kunden add CSAPP_KUNDENCODE varchar(255)