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 .csv suffix or ?format=csv
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: apex.nikoratrade.ge Accept: text/csv
HTTP/1.1 200 OK Content-Type: text/csv 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)\/"}]}