Locations

[dbo.locations]

Column name	Key	Data type	Allow NULLs	Default	Description
locationID	Primary Key	INT	☐
locationName		VARCHAR(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_schemaName	Parent_tableName	Parent_columnName	Schema	table	column	constraint_name
dbo	locations	locationID	dbo	circuits	locationID	FK_Circuits_LocationID

Example Query

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

Example Output

locationID	locationName
1	Abu Dhabi
2	Adelaide