Clears (drops) tables in the database cluster. The operation is synchronous meaning that the tables will be cleared before the function returns. The response payload returns the status of the operation for each table requested.
Input Parameter Description
| Name | Type | Description | ||||
|---|---|---|---|---|---|---|
| table_names | array of strings | Names of the tables to be cleared, in [schema_name.]table_name format, using standard name resolution rules. Must be existing tables. Empty list clears all available tables, though this behavior is be prevented by default via gpudb.conf parameter 'disable_clear_all'. The default value is an empty array ( [] ). | ||||
| options | map of string to strings | Optional parameters. The default value is an empty map ( {} ).
|
Output Parameter Description
| Name | Type | Description |
|---|---|---|
| tables | map of string to strings | For each table in input parameter table_names, any error from the clear operation, or an empty string if successful. |
| info | map of string to strings | Additional information. |
