--creazione campi Anagrafica Articolo
IF NOT EXISTS (select * from Information_SCHEMA.columns where Table_name='Articolo' and column_name='StampaInStagione')
ALTER TABLE Articolo ADD
StampaInStagione int NOT NULL CONSTRAINT DF_Articolo_StampaInStagione DEFAULT 0

GO

IF NOT EXISTS (select * from Information_SCHEMA.columns where Table_name='Cliente' and column_name='CodiceCard')
ALTER TABLE dbo.Cliente ADD CodiceCard nvarchar(50) NOT NULL CONSTRAINT DF_Cliente_CodiceCard  DEFAULT ''

GO

