Suppliers
From Transact-SQL Reference
Transact-SQL Reference
Suppliers
| Column_name |
Data type |
Nullable |
Default |
Check |
Key/index |
| SupplierID |
int |
no |
IDENTITY (1,1) |
|
PK clust. |
| CompanyName |
nvarchar(40) |
no |
|
|
Nonclust. |
| ContactName |
nvarchar(30) |
yes |
|
|
|
| ContactTitle |
nvarchar(30) |
yes |
|
|
|
| Address |
nvarchar(60) |
yes |
|
|
|
| City |
nvarchar(15) |
yes |
|
|
|
| Region |
nvarchar(15) |
yes |
|
|
|
| PostalCode |
nvarchar(10) |
yes |
|
|
Nonclust. |
| Country |
nvarchar(15) |
yes |
|
|
|
| Phone |
nvarchar(24) |
yes |
|
|
|
| Fax |
nvarchar(24) |
yes |
|
|
|
| HomePage |
ntext |
yes |
|
|
|