Get all foreign keys
get
/database/objects/foreign_keys/
Returns all records where the constraint type is 'R' from DBA_CONSTRAINTS and DBA_CONS_COLUMNS, or ALL_CONSTRAINTS and ALL_CONS_COLUMNS, views depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
Request
Query Parameters
-
limit(optional):
The maximum number of records to return.
-
q(optional):
Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
Response
200 Response
Describes all constraint definitions, with constraint type 'R', on all tables in the database.