Customers

Table Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
ID	2073058421
Located On	PRIMARY
Data Size KB	24 KB
Index Size KB	80 KB
Rows	91

Creation Options

Name	Value
QUOTED_IDENTIFIER	ON
ANSI_NULLS	ON
ANSI_PADDING	ON

Columns

Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
CustomerID		nchar	5
CompanyName		nvarchar	40
ContactName		nvarchar	30
ContactTitle		nvarchar	30
Address		nvarchar	60
City		nvarchar	15
Region		nvarchar	15
PostalCode		nvarchar	10
Country		nvarchar	15
Phone		nvarchar	24
Fax		nvarchar	24

Total: 11 column(s)

Indexes

Index	Primary	Unique
PK_Customers
City
CompanyName
PostalCode
Region

Fulltext Index

No fulltext index exist

Statistics

No statistics exist

Check Constraints

No check constraints exist

Identity Column

No identity column exists

Referencing Tables

Table	Foreign Key	Primary Key or Unique Constraint
CustomerCustomerDemo	FK_CustomerCustomerDemo_Customers	PK_Customers
Orders	FK_Orders_Customers	PK_Customers

Total: 2 table(s)

Referenced Tables

No referenced tables exist

Objects that depend on Customers

Object Name	Object Type	Dep Level
[Customer and Suppliers by City]	View	1
CustomerCustomerDemo	Table	1
CustOrderHist	Procedure	1
Invoices	View	1
[Orders Qry]	View	1
Orders	Table	1
[Quarterly Orders]	View	1
[Sales Totals by Amount]	View	1
CustOrdersOrders	Procedure	2
[Employee Sales by Country]	Procedure	2
[Order Details]	Table	2
[Product Sales for 1997]	View	2
[Sales by Category]	View	2
[Sales by Year]	Procedure	2
SalesByCategory	Procedure	2
[Summary of Sales by Quarter]	View	2
[Summary of Sales by Year]	View	2
[Category Sales for 1997]	View	3
CustOrdersDetail	Procedure	3
[Order Details Extended]	View	3
[Order Subtotals]	View	3

Total 21 object(s)

Objects that Customers depends on

No dependencies exist

Column Level Dependencies

No dependencies exist

Graphical Dependencies

Click Here to view Dependencies Graphically

Extended Properties

No extended properties defined

Permissions

No permissions defined

Table Options

Name	Value
Pintable	OFF
Table lock on bulk load	OFF
Insert row lock	OFF
Text in row	0
Large value types out of row	0

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customers] (
        [CustomerID]       nchar(5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [CompanyName]      nvarchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [ContactName]      nvarchar(30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [ContactTitle]     nvarchar(30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Address]          nvarchar(60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [City]             nvarchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Region]           nvarchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [PostalCode]       nvarchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Country]          nvarchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Phone]            nvarchar(24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Fax]              nvarchar(24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Customers]
    ADD
    CONSTRAINT [PK_Customers]
    PRIMARY KEY
    ([CustomerID])
    ON [PRIMARY]
GO
CREATE INDEX [City]
    ON [dbo].[Customers] ([City])
    ON [PRIMARY]
GO
CREATE INDEX [CompanyName]
    ON [dbo].[Customers] ([CompanyName])
    ON [PRIMARY]
GO
CREATE INDEX [PostalCode]
    ON [dbo].[Customers] ([PostalCode])
    ON [PRIMARY]
GO
CREATE INDEX [Region]
    ON [dbo].[Customers] ([Region])
    ON [PRIMARY]
GO