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

It may depend on what flavor of SQL, but whenever you want to get rid of something, DROP is generally your friend.

DROP INDEX <indexname>;

is likely to be the command needed, with various options depending on, again, exactly what flavor of SQL you're talking about.