Creating a unique index

[Tom Schindl]

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

signature.asc
Description: This is a digitally signed message part