The second form uses a LIKE clause to create a table that has the same column names and column attributes as another table. To drop any columns in the new table, you can specify the DROP= data set ...

DROP INDEX idx_a, idx_b, idx_c ON table_name Now that the stupid syntax is out of the way! An index in SQL is like the index in a book - It provides an easier way to find specific data.

DROP Command : Type of Command - DROP is a DDL (Data Definition Language) command. Purpose - Deletes the entire table definition and its contents or database or other database objects.