Skip to main content

Nationalities

[dbo.nationalities]

Column nameKeyData typeAllow NULLsDefaultDescription
nationalityIDPrimary KeyINT
nationalityVARCHAR(50)Nationality E.G. British

Table Relationships

This table has no foreign keys with any other tables

Where Used

Where is this table referenced and what columns are used? The below table shows that information.

[dbo.nationalities]

Parent_schemaNameParent_tableNameParent_columnNameSchematablecolumnconstraint_name
dbonationalitiesnationalityIDdboconstructorsnationalityIDFK_constructors_NationalityID
dbonationalitiesnationalityIDdbodriversnationalityIDFK_Drivers_NationalityID

Example Query

SELECT 
[nationalityID]
,[nationality]
FROM
[dbo].[nationalities]

Example Output

nationalityIDnationality
1nationality
2American