IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE ID = OBJECT_ID('SERV_OS') AND name = 'DS_OBJETIVO')
BEGIN
	ALTER TABLE SERV_OS ADD
		DS_OBJETIVO VARCHAR(1000) NOT NULL CONSTRAINT DF_SERV_OS_DS_OBJETIVO DEFAULT ('') 
		
END


IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE ID = OBJECT_ID('SERV_OS') AND name = 'DS_SCOOPO')
BEGIN
	ALTER TABLE SERV_OS ADD
		DS_SCOOPO VARCHAR(1000) NOT NULL CONSTRAINT DF_SERV_OS_DS_DS_SCOOPO DEFAULT ('') 
		
END


IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE ID = OBJECT_ID('SERV_OS') AND name = 'NR_CASO')
BEGIN
	ALTER TABLE SERV_OS ADD
		NR_CASO INT NOT NULL CONSTRAINT DF_SERV_OS_DS_NR_CASO DEFAULT (0) 
		
END

IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE ID = OBJECT_ID('SERV_OS') AND name = 'VLR_SERV_COM_IMPOSTO')
BEGIN
	ALTER TABLE SERV_OS ADD
		VLR_SERV_COM_IMPOSTO MONEY NOT NULL CONSTRAINT DF_SERV_OS_DS_VLR_SERV_COM_IMPOSTO DEFAULT (0) 
		
END