Suppliers Table

Description

Suppliers' names, addresses, phone numbers, and hyperlinks to home pages.

Fields

Name	Type	Attributes	Default	Description
SupplierID	int	Auto Increment		Number automatically assigned to new supplier.
CompanyName	nvarchar(40)
ContactName	nvarchar(30)	Nullable
ContactTitle	nvarchar(30)	Nullable
Address	nvarchar(60)	Nullable		Street or post-office box.
City	nvarchar(15)	Nullable
Region	nvarchar(15)	Nullable		State or province.
PostalCode	nvarchar(10)	Nullable
Country	nvarchar(15)	Nullable
Phone	nvarchar(24)	Nullable		Phone number includes country code or area code.
Fax	nvarchar(24)	Nullable		Phone number includes country code or area code.
HomePage	ntext	Nullable		Supplier's home page on World Wide Web.

Indexes

Name	Columns	Unique
CompanyName	CompanyName	no
PostalCode	PostalCode	no

Relationships

See Also

Tables | Views | Stored Procedures