Hi Rambabu,

the index on a character field can not get larger than about 70 bytes.
Yours would be 80 bytes long, and that's too long.

This limit will fall in Firebird 2.0.


Best Regards

Stefan

> Hi,
>
> When I am trying to create the table in firebird database using the
> following Script I a getting "Key size too big RDB$PRIMARY8" Exception.
> CREATE TABLE TABLE2 (
> FIELD1 VARCHAR(40) NOT NULL,
> FIELD2 VARCHAR(40) NOT NULL,
> FIELD3 VARCHAR(40),
> PRIMARY KEY(FIELD1, FIELD2), FOREIGN KEY(FIELD1)
> REFERENCES TABLE1(FIELD1) ON DELETE CASCADE);
> where FIELD1 is the primary key in the table TABLE2 and its maximum
> length is 40 characters.
> Can anyone specify me the reason for getting this error.

--
Stefan Heymann
www.destructor.de/firebird