Countries
[dbo.countries]
Column name | Key | Data type | Allow NULLs | Default | Description |
---|---|---|---|---|---|
countryID | Primary Key | INT | ☐ | ||
country | VARCHAR(255) | ☑ | Name of the country, E.G. United States |
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.countries]
Parent_schemaName | Parent_tableName | Parent_columnName | Schema | table | column | constraint_name |
---|---|---|---|---|---|---|
dbo | countries | countryID | dbo | circuits | countryID | FK_Circuits_CountryID |
Example Query
SELECT
[countryID]
,[country]
FROM
[dbo].[countries]
Example Output
countryID | country |
---|---|
1 | Argentina |
2 | Australia |