dbo.Suppliers

Field Name	Type and Size	Default	Nullable
SupplierID	int identity		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
HomePage	ntext		NULL

Primary key for table 'dbo.Suppliers'

Primary Key Name	Fields
PK_Suppliers	SupplierID

Indexes for table 'dbo.Suppliers', 3 items

Index Name	Clustered	Unique	Fields
PK_Suppliers	Yes	Yes	SupplierID
CompanyName	No	No	CompanyName
PostalCode	No	No	PostalCode

Dependencies for table 'dbo.Suppliers', 1 item

Object Name	Type
dbo.Customer and Suppliers by City	view