Hello Tom, Just use <unique> element as: <unique> <unique-column name="MyColumn"/> ----> I don't remember if this is the correct syntax. </unique> Take a look at the XML DTD. You will find many answers to your XML doubts there.
Best regards, Daniel. --- Tom Schindl <[EMAIL PROTECTED]> wrote: > Hello, > > How can I create a unique index. When using the index-Element I couldn't > set a unique flag, still when looking into the SQL-Templates there's a > test for a unique. The resulting SQL-Create-Statement should look like > this. > > CREATE TABLE tableA > ( > ab INT NOT NULL, > bc DATE NOT NULL > ) > > CREATE UNIQUE INDEX index_00 ON tableA ( ab, bc ); > > How is this done? > > thanks > > tom > > ATTACHMENT part 2 application/pgp-signature name=signature.asc ===== ----------------------------------------- Daniel H. F. e Silva Analista de Sistemas SBPI __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
