get_table_constraints
Retrieve primary keys, foreign keys, unique, and check constraints for a specified table in Oracle databases. Specify table name and optionally schema name to streamline database introspection and analysis.
Instructions
Get constraints (primary keys, foreign keys, unique, check) for a table
Input Schema
Name | Required | Description | Default |
---|---|---|---|
schema | No | Schema name (optional, searches all accessible schemas if not specified) | |
table_name | Yes | Table name |
Input Schema (JSON Schema)
{
"properties": {
"schema": {
"description": "Schema name (optional, searches all accessible schemas if not specified)",
"type": "string"
},
"table_name": {
"description": "Table name",
"type": "string"
}
},
"required": [
"table_name"
],
"type": "object"
}