This command is used to delete an existing table.
DROP TABLE [IF EXISTS] [db_name.]table_name;
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. |
In this command, IF EXISTS and db_name are optional.
DROP TABLE IF EXISTS hudidb.h1;
The table will be deleted.