Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Which command is used to remove an index from the database in SQL?

<p>A. DELETE INDEX </p> <p>B. DROP INDEX </p> <p>C. REMOVE INDEX </p> <p>D. ROLL BACK INDEX </p> <p>E. None of the above</p>

user-image
Question added by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date Posted: 2015/01/11
Vinod Jetley
by Vinod Jetley , Assistant General Manager , State Bank of India

B. DROP INDEX

Muhammad Saad Abbasi
by Muhammad Saad Abbasi , Full Stack .Net Developer , Sofnix

DROP INDEX idx_lastname ON employees;

Muhammad Zohaib Great
by Muhammad Zohaib Great , Software Test Engineer II , Mazik Global, a Quisitive Company (Tyler Technologies Inc, Texas, USA)

The DROP INDEX command is used to remove an index from a database table in SQL. The specific syntax varies slightly across different database systems: SQL DROP INDEX table_name.index_name;

Muhammad Ahmad
by Muhammad Ahmad , Oracle Identity Manager Developer , Techaccess Pakistan

In SQL, the command used to remove an index from a database is 'DROP INDEX'.

Zeeshan Ahmad
by Zeeshan Ahmad , Full Stack developer , SigmaLabs

In SQL, the command used to remove an index from the database is DROP INDEX. The syntax is as follows:

DROP INDEX index_name ON table_name;

Where index_name is the name of the index that you want to drop and table_name is the name of the table from which you want to remove the index.

 

Faraaz Rehan Junaidi Mohammed
by Faraaz Rehan Junaidi Mohammed , Research and Development Intern , FewCuts Inc.

Option b, Drop Index

Mahesh Hegde
by Mahesh Hegde , Automation Engineer , MaxLinear technologies Pvt Ltd

Drop index which not only deletes the index but also completly removes that from database

Naseeb ul Hassan
by Naseeb ul Hassan , IT Assistant , Iqra University Islamabad Campus

We can use DROP INDEX for removing Index in SQL

Hussam Alhayek
by Hussam Alhayek , Website Administrator , Arabic Calligraphy by Everitte Barbee

DROP INDEX TABLE-NAME.INDEX-NAME

Lahari Bhumireddy
by Lahari Bhumireddy , Software Developer , Eka software solutions

we can use DROP INDEX .because drop is use to remove the data from database.

Thahasim C
by Thahasim C , Accountant , Apco

Which command is used to remove an index from the database in SQL?

More Questions Like This