Create Unique Index comes up with "Key size too big" error
Posted on 2006-06-18
This is the statement I'm trying to run on a Firebird database:
CREATE UNIQUE INDEX "iName_Software" ON "Software"("Name");
Unfortunately, it comes up with this error:
This operation is not defined for system tables. Unsuccessful metadata update.
Key size too big for index iName_Software
Anyone with ideas on why this occurs? I would've thought this would be fairly standard.