CREATE TABLE [dbo].[AnagImpianti] (
    [CodImpianto]  NVARCHAR (50) NOT NULL,
    [CodCS]        NCHAR (2)     NOT NULL,
    [DescImpianto] NVARCHAR (50) NULL,
    [Campionatura] NCHAR (1)     NULL,
    [TipoLinea]    NVARCHAR (6)  NULL,
    CONSTRAINT [PK_AnagImpianti_1] PRIMARY KEY CLUSTERED ([CodImpianto] ASC),
    CONSTRAINT [FK_AnagImpianti_AnagCompanySito] FOREIGN KEY ([CodCS]) REFERENCES [dbo].[AnagCompanySito] ([CodCS]) ON UPDATE CASCADE
);

