mssql_get_relationships
Retrieve foreign key relationships between tables in Microsoft SQL Server databases to understand data connections and maintain referential integrity.
Instructions
Get foreign key relationships for tables
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database name | |
| encrypt | No | Use encrypted connection (default: true) | |
| password | Yes | Password for authentication | |
| port | No | Port number (default: 1433) | |
| server | Yes | MSSQL Server hostname or IP address | |
| table | No | Table name (optional - if not provided, gets all relationships) | |
| trustServerCertificate | No | Trust server certificate (default: true) | |
| user | Yes | Username for authentication |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name",
"type": "string"
},
"encrypt": {
"default": true,
"description": "Use encrypted connection (default: true)",
"type": "boolean"
},
"password": {
"description": "Password for authentication",
"type": "string"
},
"port": {
"default": 1433,
"description": "Port number (default: 1433)",
"type": "number"
},
"server": {
"description": "MSSQL Server hostname or IP address",
"type": "string"
},
"table": {
"description": "Table name (optional - if not provided, gets all relationships)",
"type": "string"
},
"trustServerCertificate": {
"default": true,
"description": "Trust server certificate (default: true)",
"type": "boolean"
},
"user": {
"description": "Username for authentication",
"type": "string"
}
},
"required": [
"server",
"user",
"password",
"database"
],
"type": "object"
}