1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| CREATE TABLE [dbo].[T_Comptes](
[Id_Compte] [int] IDENTITY(1,1) NOT NULL,
[Nom] [varchar](50) NOT NULL,
[Actif] [bit] NOT NULL,
[Numéro] [varchar](50) NOT NULL,
[Agence] [varchar](50) NOT NULL,
[Solde Initial] [numeric](18, 2) NULL,
[Contact] [varchar](max) NULL,
[Commentaires] [varchar](max) NULL,
[Montant Ecritures] [numeric](18, 2) NULL,
[Montant Ecritures Pointées] [numeric](18, 2) NULL,
[Personne_Id] [int] NOT NULL,
[Réserve] [varchar](50) NULL,
CONSTRAINT [PK_T_Comptes] PRIMARY KEY CLUSTERED
(
[Id_Compte] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_T_Comptes] ON [dbo].[T_Comptes]
(
[Personne_Id] ASC,
[Nom] 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)
GO |
Partager