Subject Primary Key Size Error
Author Dilish
Hi all

CREATE TABLE ispFmt10 (RCA SMALLINT DEFAULT 1 NOT NULL,DORD VARCHAR
(1) NOT NULL,DNME VARCHAR(100),MMOD VARCHAR(50) NOT NULL,MODL VARCHAR
(50) NOT NULL,SMOD VARCHAR(50) NOT NULL,CurrOpt VARCHAR(1) NOT
NULL,DTYP VARCHAR(3) NOT NULL,SID INTEGER DEFAULT 0 NOT NULL,SNODE
VARCHAR(50),FL1 VARCHAR(50),FLDFR VARCHAR(50),MDBN VARCHAR(50),LnkMdb
VARCHAR(50),LKT VARCHAR(50) PRIMARY KEY
(RCA,DORD,MODL,MMOD,SMOD,DTYP,SID))

While Executing the query it gives the following error

key size too big for index RDB$PRIMARY13.

TIA

Dilish