# Create inxed using alter table **URL:** \ **Category:** Toad Data Modeler\ **Created:** [January 24, 2012, 8:40am UTC](https://forums.toadworld.com/t/create-inxed-using-alter-table/2629 "2012-01-24T08:40:47Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Michal.K](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Michal.K](https://forums.toadworld.com/u/Michal.K)\ **Post date:** [January 24, 2012, 8:40am UTC](https://forums.toadworld.com/t/create-inxed-using-alter-table/2629/1 "2012-01-24T08:40:47Z")
hello I would like to ask for option making possible to generate index into DDL by using ALTER TABLE ADD INDEX syntax. Current one (CREATE INDEX) requires INDEX privilege and often fails on shared hosting machines. Adding index using alter syntax requires only ALTER privilege which is usually available. In any way, such option would be useful at least to me 😉 ---
**Author:** ![Vaclav\_Frolik](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vaclav_frolik/32/12_2.png) [@Vaclav\_Frolik](https://forums.toadworld.com/u/Vaclav_Frolik)\ **Post date:** [January 24, 2012, 10:24am UTC](https://forums.toadworld.com/t/create-inxed-using-alter-table/2629/2 "2012-01-24T10:24:50Z")
Hi Michal, thank you for your suggestion. Please add it to the Idea Pond at [http://toaddatamodeler.ideascale.com](http://toaddatamodeler.ideascale.com/) Thank you! Vaclav ---
**Author:** ![Michal.K](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Michal.K](https://forums.toadworld.com/u/Michal.K)\ **Post date:** [January 26, 2012, 5:04am UTC](https://forums.toadworld.com/t/create-inxed-using-alter-table/2629/3 "2012-01-26T05:04:57Z")
Thanx I started to ‘flood’ Idea Pond system with ideas. Looks I’m almost the first one. Is there any way to further track ideas? if one has been accepted, is under development, when release is scheduled etc.