Yang, Tong 6182f91ba8 MRS component operation guide_normal 2.0.38.SP20 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2022-12-09 14:55:21 +00:00

3.5 KiB

Raw Permalink Blame History

DROP TABLE

Function

This command is used to delete an existing table.

Syntax

DROP TABLE [IF EXISTS] [db_name.]table_name;

Parameter Description

**Table 1** DROP TABLE parameters
Parameter	Description
db_name	Database name. If this parameter is not specified, the current database is selected.
table_name	Name of the table to be deleted

Precautions

In this command, IF EXISTS and db_name are optional.

Example

DROP TABLE IF EXISTS productDatabase.productSalesTable;

System Response

The table will be deleted.

Parent topic: DDL

3.5 KiB Raw Permalink Blame History