list_constraints
Identify and retrieve all database constraints, including check, unique, foreign key, and primary key constraints, across tables in Microsoft SQL Server for enhanced schema analysis and management.
Instructions
List all constraints (check, unique, foreign key, etc.) across tables in the database
Input Schema
Name | Required | Description | Default |
---|---|---|---|
connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
connectionString | No | SQL Server connection string (uses default if not provided) | |
constraintType | No | Filter by constraint type (default: ALL) | |
schema | No | Schema name (default: dbo) |