Re: autoincrement of non primary key

[Kostyantyn Shchekotykhin]

Hi Dave,
For unique indexes are created with the following lines:
#foreach ($unique in $table.Unices)
    CONSTRAINT $unique.Name UNIQUE ($unique.ColumnList),
#end
as you can see you will receive one CONSTRAINT for each unique element, 
so your index will contain 3 columns.

Regards,
Kostya
Dave Newton wrote:

On Thu, 2004-03-04 at 01:15, Thomas Edwin Santosa wrote:

<unique name="foo">
   <unique-column name="SESSION_ID"/>
   <unique-column name="SECTION_ID"/>
   <unique-column name="ACTIVITY_ID"/>
</unique>


Will that make the group of them unique, or each one?

Dave



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]