| 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 |