Skip to main content

Locations

[dbo.locations]

Column nameKeyData typeAllow NULLsDefaultDescription
locationIDPrimary KeyINT
locationNameVARCHAR(255)Location Name E.G. Las Vegas

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.locations]

Parent_schemaNameParent_tableNameParent_columnNameSchematablecolumnconstraint_name
dbolocationslocationIDdbocircuitslocationIDFK_Circuits_LocationID

Example Query

SELECT 
[locationID]
,[locationName]
FROM
[dbo].[locations]

Example Output

locationIDlocationName
1Abu Dhabi
2Adelaide