Skip to main content

Circuit Types

[dbo.circuitTypes]

Column nameKeyData typeAllow NULLsDefaultDescription
circuitTypeIDPrimary KeyINT
circuitTypeVARCHAR(50)Type of circuit E.G. Street

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

Parent_schemaNameParent_tableNameParent_columnNameSchematablecolumnconstraint_name
dbocircuitTypescircuitTypeIDdbocircuitscircuitTypeIDFK_Circuits_CircuitTypeID

Example Query

SELECT 
[circuitTypeID]
,[circuitType]
FROM
[dbo].[circuitTypes]

Example Output

circuitTypeIDcircuitType
1Street circuit
2Race circuit