Re: [Firebird-devel] User-defined index names for PK/FK/UK constraints (DESC)

[Alexander P. <Peshkoff@HotMail.ru>]

Hi!
I think this syntax will be OK:

<tconstraint> =3D [CONSTRAINT constraint]
{{PRIMARY KEY | UNIQUE} ( col [, col =85]) [INDEX index [ASC/DESC]]
| FOREIGN KEY ( col [, col =85]) REFERENCES other_table
[ON DELETE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}]
[ON UPDATE {NO ACTION|CASCADE|SET DEFAULT|SET NULL}] [INDEX index
[ASC/DESC]]
| CHECK ( <search_condition>)}

Alex.