How to create an index:
CREATE INDEX IX_TMP_SETRENTCHARGE ON T_TMP_SETRENTCHARGE (Phonenumber);
Create an index called IX_TMP_SETRENTCHARGE in the phonenumber field of the T_TMP_SETRENTCHAREGE table;
How to delete an index:
Index is deleted while Drop Table!