You can execute the DROP TABLE statement to delete a table. This topic describes how to use the DROP TABLE statement to delete a table.
DROP TABLE [ IF EXISTS ] table_name [, ...];
DROP TABLEstatement to delete multiple tables at a time.
|table_name||The name of the table that you want to delete.|
DROP TABLE holo_test;
Use HoloWeb to visually delete a table
You can use HoloWeb to visually delete a table without the need to write SQL statements. To do so, perform the following steps:
- Go to the HoloWeb console. For more information, see HoloWeb quick start.
- In the top navigation bar of the HoloWeb console, click Metadata Management.
- Go to the Metadata Management page of the HoloWeb console. In the left-side Instance Management pane, right-click the table that you want to delete in the Instances Connected section and select Delete Table.
- In the Delete table message, click OK.