remove table index in sql

SQL ALTER TABLE  statement is used to modify the data type of a column , add a new column ,delete an old column from table and add a new constraints and remove an existing constraints on table.