AdventureWorks

Basic Index   Expanded Index

Table Name:Person.CountryRegion
Description:Lookup table containing the ISO standard codes for countries and regions.
Primary Keys:CountryRegionCode
FieldTypeDefaultsNulls?Comments
CountryRegionCodenvarchar (3)NoneNoISO standard code for countries and regions.
Namenvarchar (50)NoneNoCountry or region name.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_CountryRegion_CountryRegionCodeYesYesCountryRegionCode
AK_CountryRegion_NameNoYesName

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_CountryRegionCurrency_CountryRegion_CountryRegionCodeSales.CountryRegionCurrencyCountryRegionCode
FK_StateProvince_CountryRegion_CountryRegionCodePerson.StateProvinceCountryRegionCode

No triggers