Generated using SQL Data Dictionary demo version.

Table Application.Cities (37,940 rows)

Cities that are part of any address (including geographic location)

  Column Data Type Identity Nullable Default
PK CityID int NEXT VALUE FOR [Sequences].[CityID]
Numeric ID used for reference to a city within the database
CityName nvarchar(50)
Formal name of the city
FK StateProvinceID int
State or province for this city
Location geography X
Geographic location of the city
LatestRecordedPopulation bigint X
Latest available population for the City
FK LastEditedBy int
ValidFrom datetime2
ValidTo datetime2



Referenced by:

Used by: