
--creazione campo SyncFCBen in tabella Negozio
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Negozio' AND COLUMN_NAME = 'SyncFCBen')
BEGIN
ALTER TABLE dbo.Negozio ADD	SyncFCBen datetime NULL
END

--creazione campo IVA in tabella ScontrinoD
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ScontrinoD' AND COLUMN_NAME = 'IVA')
BEGIN
ALTER TABLE dbo.ScontrinoD ADD	IVA nvarchar(50) NULL
END





