Register now or log in to join your professional community.
<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>
B. DROP INDEX
In SQL, the command used to remove an index from a database is 'DROP INDEX'.
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.
Option b, Drop Index
Drop index which not only deletes the index but also completly removes that from database
We can use DROP INDEX for removing Index in SQL
DROP INDEX TABLE-NAME.INDEX-NAME
we can use DROP INDEX .because drop is use to remove the data from database.