Get a list of indexes on a table.
GET {{baseUrl}}/tables/:tableNameOrId/indexes?compartmentId={{compartment_ocid}}&name=*&lifecycleState=ALL&limit=1000&page=ea dolore dolor&sortOrder=DESC&sortBy=timeCreated
Get a list of indexes on a table.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
compartmentId | string | The ID of a table's compartment. When a table is identified | |
by name, the compartmentId is often needed to provide | |||
context for interpreting the name. | |||
name | string | A shell-globbing-style (*?[]) filter for names. | |
lifecycleState | string | Filter list by the lifecycle state of the item. | |
limit | number | The maximum number of items to return. | |
page | string | The page token representing the page at which to start | |
retrieving results. This is usually retrieved from a previous | |||
list call. | |||
sortOrder | string | The sort order to use, either 'ASC' or 'DESC'. | |
sortBy | string | The field to sort by. Only one sort order may be | |
provided. Default order for timeCreated is descending. Default | |||
order for name is ascending. If no value is specified | |||
timeCreated is default. | |||
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Accept | string |
RESPONSES
status: OK
{"items":[{"keys":[{"columnName":"amet in","jsonFieldType":"d","jsonPath":"in p"},{"columnName":"deserunt","jsonFieldType":"aliquip ullamco eiusm","jsonPath":"consequat labo"}],"lifecycleDetails":"ut incididunt proident eiusmod","lifecycleState":"consectetur sit sunt","name":"ad commo"},{"keys":[{"columnName":"voluptate ullamco velit enim aute","jsonFieldType":"ut enim dolor elit adipisicing","jsonPath":"commodo cillum id labore"},{"columnName":"elit consequat officia Exc","jsonFieldType":"magna adipisicing ei","jsonPath":"in qui sunt sed consectetur"}],"lifecycleDetails":"reprehenderit quis pariatur nul","lifecycleState":"proident cillum Ut magna labore","name":"in magna"}]}