Torna al Thread
CREATE TABLE [dbo].[Albergo](
[Codalb] [int] NOT NULL,
[Descrizione] [varchar](250) NULL,
[CodComune] [int] NOT NULL,
CONSTRAINT [PK_Albergo] PRIMARY KEY CLUSTERED
( [Codalb] ASC,
[CodComune] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[Anagrafica_camere](
[Id] [int] IDENTITY(1,1) NOT NULL,
[codalbergo] [int] NULL,
[codicecomune] [int] NULL,
[nrletti] [int] NULL,
[nrlettiextra] [int] NULL,
CONSTRAINT [PK_Anagrafica_camere] PRIMARY KEY CLUSTERED
( [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[Archivio_mov_new](
[IdDb] [bigint] IDENTITY(1,1) NOT NULL,
[codalbergo] [int] NULL,
[codcomalbergo] [int] NULL,
[DataArrivo] [smalldatetime] NULL,
CONSTRAINT [PK_Archivio_mov_new] PRIMARY KEY CLUSTERED
( [IdDb] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO