Stores region information.
| Creation Date | 5/10/2011 11:10 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object | ![]() |
| Published for Replication | ![]() |
| Rows | 10 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| GeoRegionSID | Unique system-generated sequential identifier for the geographic region record. | int | 4 | |||
| Region | Region name.
| varchar | 255 | ![]() | |||
| Description | Region description, often an abbreviation. For example, CA for Central America. | varchar | 4000 | ![]() | |||
| guidExternal | GUID of the boundary as supplied from tblAreaExternal. | binary | 16 | ![]() | |||
| IsUsedInGeoFilter | Indicates whether the region is to be used in a geographic region filter.
| bit | 1 | ![]() |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
![]() | tCountryGeoRegionXref | Table | Stores the geographic region that corresponds to each country. | 1 |
![]() | tGeoCountry | Table | Stores values that indicate the type of reverse geocoding that the application supports for each country. | 1 |