Well, that's not what I've been aming at. When declaring a column/set of colums to be unique it does not automitcally mean that they're indexed. It's only a constraint. That's exactly what torque does and what it should do. You can see this when looking e.g. at the sql-Templates for Oracle.
That's why my question remains the same. How can I create a UNIQUE INDEX? There exists a Unique attribute in the template-files ($index.Unique) still the DTD does not provide an attribute to declare an index to be UNQUE. Has this been forgotten when creating the DTD? thanks for your help tom Am Mit, 2002-11-13 um 12.15 schrieb Daniel H. F. e Silva: > 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:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- b e s t s o l u t i o n . a t EDV Systemhaus GmbH ------------------------------------------------------------------------ Thomas Schindl Project Management mobile ++43/664/314 59 58 ------------------------------------------------------------------------ Anton-Rauch-Str.6a A-6020 Innsbruck fax ++43/512/935834 http://www.bestsolution.at phone ++43/512/935834
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil
