get_table_constraints
Retrieve all constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK) for a specified Firebird table, with optional type filtering.
Instructions
Return constraints on a table: PRIMARY KEY, FOREIGN KEY, UNIQUE, and CHECK. Returns [{constraint, type, index}]. Prefer inspect_table to get constraints alongside columns and FKs. For full FK details (referenced columns, ON DELETE/UPDATE rules) use get_foreign_keys instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database key from list_databases. | |
| table | Yes | Table name. Automatically uppercased. | |
| typeFilter | No | Optional case-insensitive .NET regex to filter by constraint type. Values: 'PRIMARY KEY', 'FOREIGN KEY', 'UNIQUE', 'CHECK'. Omit to return all. |