[JBoss-user] Add an index to a table on deployment

[Brian McSweeney]

Hi all,   We currently use the jboss create table tag to build our database schema on deployment using cmp entity beans.   I was wondering if there is a way to add an index to a specific column in a table. We're using mysql and having looked into it, we don't think you can add an index once the tables have been created. Any help would be much appreciated, thanks, Brian