5.2. Get a list of indexes on a table.
GET {{baseUrl}}/tables/:tableNameOrId/indexes?compartmentId={{compartment_ocid}}&name=*&lifecycleState=ALL&limit=1000&sortOrder=DESC&sortBy=timeCreated
Get a list of indexes on a table.
Body
PARAM
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 | Curl curl -X GET 'https://nosql.region.oci.oraclecloud.com/20190828/tables/:tableNameOrId/indexes?compartmentId=compartment_ocid&name=*&lifecycleState=ALL&limit=1000&sortOrder=DESC&sortBy=timeCreated?compartmentId=compartment_ocid&name=*&lifecycleState=ALL&limit=1000&page=ea dolore dolor&sortOrder=DESC&sortBy=timeCreated' -H 'opc-request-id: $randomUUID' -H 'Accept: application/json' ENDPOINTS |