dbo.Customers

Table: 'dbo.Customers', 11 fields

Field NameType and SizeDefaultNullable
CustomerIDnchar(5) NOT NULL
CompanyNamenvarchar(40) NOT NULL
ContactNamenvarchar(30) NULL
ContactTitlenvarchar(30) NULL
Addressnvarchar(60) NULL
Citynvarchar(15) NULL
Regionnvarchar(15) NULL
PostalCodenvarchar(10) NULL
Countrynvarchar(15) NULL
Phonenvarchar(24) NULL
Faxnvarchar(24) NULL

Primary key for table 'dbo.Customers'

Primary Key NameFields
PK_CustomersCustomerID

Indexes for table 'dbo.Customers', 5 items

Index NameClusteredUniqueFields
PK_CustomersYesYesCustomerID
CityNoNoCity
CompanyNameNoNoCompanyName
PostalCodeNoNoPostalCode
RegionNoNoRegion

Dependencies for table 'dbo.Customers', 6 items

Object NameType
dbo.CustOrderHiststored procedure
dbo.Customer and Suppliers by Cityview
dbo.Invoicesview
dbo.Orders Qryview
dbo.Quarterly Ordersview
dbo.Sales Totals by Amountview