INDEX


Create INDEX  is used to create indexes in tables.
Indexes are used to rapidly create and retrieve data in a tables.

Syntax :-

CREATE INDEX index_name
ON table_name (column1,  column2,.................,columnN);
Example : let's how to create index statement in table.

Query :
CREATE INDEX ind_id
ON student (name);
Output : 

Now, you can see INDEX created in student table.


Drop  an INDEX Constraints 


To drop an INDEX constraints , use the following syntax in sql :

Query :-
ALTER TABLE student 
DROP ind_id;
Example : Let's see how to drop index in table.

Output :