Dark Mode

Prerequisites

Dropping a type

You can delete a type. All tables that use the UDT must first be deleted.

Dropping a table

You can delete a table. All data will be deleted along with the table schema.

IF EXISTS option

You can delete a table after checking that it exists with the ifExists option.All data will be deleted along with the table schema.

Dropping columns from table schema

If you find an attribute is no longer required in a table, you can remove a column.All column data will be deleted along with the column schema.

Dropping an index from table schema

If you find an index is no longer required on a table column, or you need to change the index,you can remove it.All index data will be deleted along with the index schema.