Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| stateID | int identity | 4 | √ | null |
|
|
Primary key - state unique identifier for each record |
|
| stateCode | nchar | 4 | null |
|
|
State code - Two or three character abbreviation for the state |
||
| stateName | nvarchar | 256 | null |
|
|
State name - Full name of the state or province |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_state | Primary key | Asc | stateID |