
/*------ ATD 331377 ------*/
-- SQL Server
-- Adiciona a coluna xNEmp na tabela DadosItemNFE
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'XNEMP' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='DADOSITEMNFE'))
ALTER TABLE DADOSITEMNFE ADD XNEMP VARCHAR(40)
GO