| View previous topic :: View next topic |
| Author |
Message |
manoj
Joined: 21 Aug 2007
Posts: 100
|
 Posted: Fri Jan 29, 2010 10:29 am Post subject: SQL Command to delete index |
 |
|
Hi,
I have created index on the table.Can any one tell me sql command for deleting index on the table.
Regards,
Manoj. |
|
| Back to top |
|
 |
venkat
Joined: 21 Aug 2007
Posts: 161
|
| Posted: Fri Jan 29, 2010 10:36 am Post subject: |
|
|
SQL Command for deleting index is
Drop index tablename.indexname
For example let us think that we have created salary index on employee table
DROP Index employee.salary //employee is the table name and salary is index name. |
|
| Back to top |
|
|
|
