# no way to specify clustered or nonclustered index in createIndex

**URL:** https://forum.liquibase.org/t/no-way-to-specify-clustered-or-nonclustered-index-in-createindex/460
**Category:** General Discussion
**Created:** [February 21, 2010, 7:41am UTC](https://forum.liquibase.org/t/no-way-to-specify-clustered-or-nonclustered-index-in-createindex/460 "2010-02-21T07:41:00Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![skrlswamy](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@skrlswamy](https://forum.liquibase.org/u/skrlswamy)
#### Post date: [February 21, 2010, 7:41am UTC](https://forum.liquibase.org/t/no-way-to-specify-clustered-or-nonclustered-index-in-createindex/460/1 "2010-02-21T07:41:00Z")

</div>

Hi,  
I’m not able to find a way to specify the createIndex with clusteredIndex or nonClusteredIndex options.  
Could you please tell me the way to specify this in changeSets?

I tried to generate the changelog on the tables with the clustered indexes, bu the generated index does not contain any information related to this.

---

<div class="post-metadata">

### Author: ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)
#### Post date: [February 21, 2010, 7:41am UTC](https://forum.liquibase.org/t/no-way-to-specify-clustered-or-nonclustered-index-in-createindex/460/2 "2010-02-21T07:41:00Z")

</div>

We currently do not support an attribute in the createIndex node for clustered configuration, and do not check for it in the diff tool used for generateChangeLog.

You can use the modifySql tag to update the generated sql, or use the tag and specify the entire sql string.

Nathan