All Objects
get
/database/reports/data_dictionary/all_objects/all_objects/
For each object, lists the owner, name, type (table, view, index, and so on), status (valid or invalid), the date it was created, and the date when the last data definition language (DDL) operation was performed on it. The Last DDL date can help you to find if any changes to the object definitions have been made on or after a specific time.
Request
Query Parameters
-
OBJECT_NAME(optional): string
Object Name
-
OWNER(optional): string
Owner
-
limit(optional): integer(int32)
The maximum number of records to return.
-
offset(optional): integer(int32)
The index of the first record to start returning results for. Used with pagination.
Response
200 Response
The response returned by SQL Report Data endpoints will conform to this general pattern of paginated records. The actual structure of each item will vary depending on the report, the database version and the user's permissions.
Root Schema : ItemsCollection
Type:
Show Source
object
-
count(optional):
integer
Total number of records in the current response.
-
hasMore(optional):
boolean
Indicates if there are more records to be retrieved.
-
items(optional):
array items
-
limit(optional):
integer
The actual page size limit on number of records applied by the server.
-
links(optional):
array links
-
offset(optional):
integer
The actual index from which the item resources are returned.
Nested Schema : items
Type:
Show Source
array
-
Array of:
object ResourceItem
Additional Properties Allowed:
true