Hi
I want to create index for my table in SQL SERVER.
When I used
<prop key="hibernate.hbm2ddl.auto">create</prop>
or
<prop key="hibernate.hbm2ddl.auto">create-drop</prop>
Hibernate created my index, but I used
<prop key="hibernate.hbm2ddl.auto">update</prop>
my index not create in my column.
For example:
<property name="name" type="java.lang.String">
<column name="Name" sql-type="nvarchar(255)" unique="true" not-null="true" index="NAME_INDEX"/>
</property>
My database is exist and I went to update columns for create index.
Why my index doesn’t update?

If you're trying to make Hibernate Tools update the structure of an existing database: this does not work, that's beyond the capabilities of Hibernate Tools.

hbm2ddl is intended to set up a new database. Either to generate the SQL that will set up a database for a clean install, or to create and initialize a database with test data.

(This is what I have gleaned from various statements by Hibernate Tools developers in this forum, so I may be missing relevant detail.)