CREATE TABLE [dbo].[Tab_clienti](
  [idcliente] [int] NOT NULL,
  [titolo] [varchar](5) NULL,
  [cognome] [varchar](30) NULL,
  [nome] [varchar](30) NULL,
  [sesso] [bit] NULL,
  [datanascita] [smalldatetime] NULL,
  [codfiscale] [varchar](16) NULL,
  [indirizzo] [varchar](50) NULL,
  [telefono] [varchar](15) NULL,
  [cellulare] [varchar](15) NULL,
  [fax] [varchar](15) NULL,
  [email] [varchar](150) NULL,
  [idcittadinanza] [smallint] NULL,
  [idstatonascita] [smallint] NULL,
  [idluogonascita] [smallint] NULL,
  [idstatoresidenza] [smallint] NULL,
  [idluogoresidenza] [smallint] NULL,
  [idlistadocumenti] [smallint] NULL,
 CONSTRAINT [PK_Tab_clienti] PRIMARY KEY CLUSTERED 
(
  [idcliente] 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

SET

CREATE NONCLUSTERED INDEX [Key1] ON [dbo].[Tab_clienti] 
(
  [cognome] ASC,
  [nome] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [Key3]    Script Date: 06/19/2013 18:05:01 ******/
CREATE NONCLUSTERED INDEX [Key3] ON [dbo].[Tab_clienti] 
(
  [idcittadinanza] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [Key4]    Script Date: 06/19/2013 18:05:11 ******/
CREATE NONCLUSTERED INDEX [Key4] ON [dbo].[Tab_clienti] 
(
  [idstatonascita] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [Key5]    Script Date: 06/19/2013 18:05:20 ******/
CREATE NONCLUSTERED INDEX [Key5] ON [dbo].[Tab_clienti] 
(
  [idluogonascita] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [Key6]    Script Date: 06/19/2013 18:05:28 ******/
CREATE NONCLUSTERED INDEX [Key6] ON [dbo].[Tab_clienti] 
(
  [idstatoresidenza] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [Key7]    Script Date: 06/19/2013 18:05:38 ******/
CREATE NONCLUSTERED INDEX [Key7] ON [dbo].[Tab_clienti] 
(
  [idluogoresidenza] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [Key8]    Script Date: 06/19/2013 18:05:46 ******/
CREATE NONCLUSTERED INDEX [Key8] ON [dbo].[Tab_clienti] 
(
  [idlistadocumenti] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO