| Required role: | SysAdmin |
| GET | /dbadmin/servers/databases/tableinfo | ||
|---|---|---|---|
| GET | /dbadmin/servers/{ServerId}/databases/tableinfo |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| ServerId | path | string | No | |
| DbName | query | string | No | |
| Schema | query | string | No | |
| Name | query | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| ResponseStatus | form | ResponseStatus | No | |
| Result | form | List<DbServerTableInfo> | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Schema | form | string | No | |
| Name | form | string | No | |
| Owner | form | string | No | |
| DataKB | form | int | No | |
| RowCount | form | int | No | |
| value | form | string | No | |
| IndexKB | form | int | No | |
| HasClusIdx | form | bool | No | |
| Columns | form | int | No | |
| create_date | form | DateTime | No | |
| modify_date | form | DateTime | No |
To override the Content-type in your clients, use the HTTP Accept Header, append the .x-protobuf suffix or ?format=x-protobuf
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
GET /dbadmin/servers/databases/tableinfo HTTP/1.1 Host: 10.10.0.107 Accept: application/x-protobuf
HTTP/1.1 200 OK
Content-Type: application/x-protobuf
Content-Length: length
{"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}},"Result":[{"Schema":"String","Name":"String","Owner":"String","DataKB":0,"RowCount":0,"value":"String","IndexKB":0,"HasClusIdx":false,"Columns":0,"create_date":"\/Date(-62135596800000-0000)\/","modify_date":"\/Date(-62135596800000-0000)\/"}]}