/
Customers.sql
35 lines (26 loc) · 882 Bytes
/
Customers.sql
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
27
28
29
30
31
32
33
34
CREATE TABLE [dbo].[Customers] (
[CustomerID] NCHAR (5) NOT NULL,
[CompanyName] NVARCHAR (40) NOT NULL,
[ContactName] NVARCHAR (30) NULL,
[ContactTitle] NVARCHAR (30) NULL,
[Address] NVARCHAR (60) NULL,
[City] NVARCHAR (15) NULL,
[Region] NVARCHAR (15) NULL,
[PostalCode] NVARCHAR (10) NULL,
[Country] NVARCHAR (15) NULL,
[Phone] NVARCHAR (24) NULL,
[Fax] NVARCHAR (24) NULL,
CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED ([CustomerID] ASC)
);
GO
CREATE NONCLUSTERED INDEX [City]
ON [dbo].[Customers]([City] ASC);
GO
CREATE NONCLUSTERED INDEX [CompanyName]
ON [dbo].[Customers]([CompanyName] ASC);
GO
CREATE NONCLUSTERED INDEX [PostalCode]
ON [dbo].[Customers]([PostalCode] ASC);
GO
CREATE NONCLUSTERED INDEX [Region]
ON [dbo].[Customers]([Region] ASC);