CREATE TABLE [dbo].[Albergo]( 
[Codalb] [int] NOT NULL,
 [Descrizione] [varchar](250) NULL,
 [Indirizzo] [varchar](250) NULL,
 [Cap] [varchar](5) NULL, 
[Citta] [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]