Javatpoint Logo
Javatpoint Logo

Hive - Drop Table

Hive facilitates us to drop a table by using the SQL drop table command. Let's follow the below steps to drop the table from the database.

  • Let's check the list of existing databases by using the following command: -

Hive Drop Table
  • Now select the database from which we want to delete the table by using the following command: -

Hive Drop Table
  • Let's check the list of existing tables in the corresponding database.

Hive Drop Table
  • Now, drop the table by using the following command: -

Hive Drop Table
  • Let's check whether the table is dropped or not.

Hive Drop Table

As we can see, the table new_employee is not present in the list. Hence, the table is dropped successfully.

Next TopicHive - Alter Table




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA