
/*------ ATD 334802 ------*/
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'COMPLEMENTONFSAIDA' and column_name = 'DhContingencia')
ALTER TABLE COMPLEMENTONFSAIDA ADD DhContingencia DATETIME NULL
go
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'COMPLEMENTONFSAIDA' and column_name = 'JustificativaContingencia')
ALTER TABLE COMPLEMENTONFSAIDA ADD JustificativaContingencia VARCHAR(254) NULL
go
/*------ ATD 334802 ------*/
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'COMPLEMENTONFSAIDA' and column_name = 'DhContingencia')
ALTER TABLE COMPLEMENTONFSAIDA ADD DhContingencia DATETIME NULL
go
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'COMPLEMENTONFSAIDA' and column_name = 'JustificativaContingencia')
ALTER TABLE COMPLEMENTONFSAIDA ADD JustificativaContingencia VARCHAR(254) NULL
go