list_foreign_keys
Identify and display foreign key relationships within SQL Server database schemas to understand table dependencies and maintain referential integrity.
Instructions
List all foreign key relationships in a schema
Input Schema
Name | Required | Description | Default |
---|---|---|---|
database | No | Database name (optional) | |
schema | No | Schema name (optional, defaults to dbo) |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name (optional)",
"type": "string"
},
"schema": {
"description": "Schema name (optional, defaults to dbo)",
"type": "string"
}
},
"type": "object"
}