| Subject | Re: [firebird-support] Descending primary key in FB 2.0 |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2007-02-27T19:24:39Z |
Rick Debay wrote:
for some key segments and DESC for another ones).
ALTER TABLE <table name>
ADD CONSTRAINT <constraint name>
PRIMARY KEY (<columns>)
USING DESCENDING INDEX <index name>;
Dmitry
> ALTER TABLE SXC_CLAIM ADD CONSTRAINT PK_SXC_CLAIM PRIMARY KEYThe index key can be either ascending or descending *entirely* (not ASC
> (RXCLAIMNBR, CLMSEQNBR DESC, CLAIMSTS);
for some key segments and DESC for another ones).
> I had thought FB 2.0 added supportIt was in v1.5, IIRC.
> for descending primary keys
ALTER TABLE <table name>
ADD CONSTRAINT <constraint name>
PRIMARY KEY (<columns>)
USING DESCENDING INDEX <index name>;
Dmitry