Subject | Primary Key Size Error |
---|---|
Author | Dilish |
Post date | 2005-11-22T11:33:52Z |
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
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