Stores city information for the United States.
| Creation Date | 2/6/2014 3:05 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object | ![]() |
| Published for Replication | ![]() |
| Rows | 41169 |
| Data Space Used | 2,568.00 KB |
| Index Space Used | 1,624.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | |||
| GuidExternal | GUID of the boundary as supplied from tblAreaExternal. | dbo.GUID | 16 | ||||
| OldCountryCode | CLASIC/2 identifier for the country. | smallint | 2 | ||||
| CountryCode | ISO 2-character code for the country. For a complete list of codes, see tCountry Table. | varchar | 15 | ||||
| AreaCode | Area code for the city. For a complete list of codes, see tGeography Table. | varchar | 15 | ||||
| SubareaCode | Subarea code for the city. For a complete list of codes, see tGeography Table. | varchar | 15 | ||||
| PostalCode | Postal code for the city. For a complete list of codes, see tGeography Table. | varchar | 15 | ||||
| CityName | Name of the city. | varchar | 60 |