From: James Sutherland <jamesssss_at_yahoo.com>
Date: Thu, 20 Mar 2008 06:19:16 -0700 (PDT)

You can use DDL to perform such DBA tasks, either through a database tool, or
through JPA native queries.

The auto generation of tables that JPA performs is only for rapid prototype,
they are not meant to be production tables. For that I would recommend
using a DBA tool.

You can add an index through,
"Create Index MYINDEX ..."

Or alter a table through,
"Alter Table MYTABLE ..."



Kiril Minanov wrote:
>
> Hi,
>
> I want to automatically generate indexes when the tables are created but I
> cant find the notation of specifying that.
>
> Can you give me a hint?
>
> Also I would to add a new column to the table without dropping and
> recreting
> the tables from scratch.
> How can I do that?
>
> Thanks
>
>
> --
> minance
>
>


-----

---
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/Column-Indexes-tp16150393p16177891.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.