drop database <database name>;
hive> DROP TABLE IF EXISTS <tablename>;
DROP view <viewname>;
DROP INDEX <index_name> ON <table_name>;