dbo.Customers

Field Name	Type and Size	Default	Nullable
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

Primary key for table 'dbo.Customers'

Primary Key Name	Fields
PK_Customers	CustomerID

Indexes for table 'dbo.Customers', 5 items

Index Name	Clustered	Unique	Fields
PK_Customers	Yes	Yes	CustomerID
City	No	No	City
CompanyName	No	No	CompanyName
PostalCode	No	No	PostalCode
Region	No	No	Region

Dependencies for table 'dbo.Customers', 6 items

Object Name	Type
dbo.CustOrderHist	stored procedure
dbo.Customer and Suppliers by City	view
dbo.Invoices	view
dbo.Orders Qry	view
dbo.Quarterly Orders	view
dbo.Sales Totals by Amount	view