TheDeveloperBlog.com

Home | Contact Us

C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML

Hive Drop Table

Hive Drop Table with tutorial, introduction, environment setup, first app hello world, state, props, flexbox, height and width, listview, scrollview, images, buttons, router, etc.

<< Back to HIVE

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> show databases;

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

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

Hive Drop Table
  • Now, drop the table by using the following command: -
hive> drop table new_employee; 

Hive Drop Table
  • Let's check whether the table is dropped or not.
hive> show tables;

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




Related Links:


Related Links

Adjectives Ado Ai Android Angular Antonyms Apache Articles Asp Autocad Automata Aws Azure Basic Binary Bitcoin Blockchain C Cassandra Change Coa Computer Control Cpp Create Creating C-Sharp Cyber Daa Data Dbms Deletion Devops Difference Discrete Es6 Ethical Examples Features Firebase Flutter Fs Git Go Hbase History Hive Hiveql How Html Idioms Insertion Installing Ios Java Joomla Js Kafka Kali Laravel Logical Machine Matlab Matrix Mongodb Mysql One Opencv Oracle Ordering Os Pandas Php Pig Pl Postgresql Powershell Prepositions Program Python React Ruby Scala Selecting Selenium Sentence Seo Sharepoint Software Spellings Spotting Spring Sql Sqlite Sqoop Svn Swift Synonyms Talend Testng Types Uml Unity Vbnet Verbal Webdriver What Wpf