I deleted an index called byFolderId then deleted that field.  When I try to
open the table now I get error 401:  the index byFolderId does not exist.
(which is true).  The only way I can get the table to open is to create an
index called byFolderId (on any field).  What's going on?  I don't want the
field or the index.  Repairing the table didn't help.  There are no
constraints.  FolderId was just another field, not the primary key.  All
this done using the EDB Manager.  The reverse engineer code for the table is
below.

  EXECUTE IMMEDIATE 'CREATE TABLE "IGNMsgList"
                    (
                    "PK" INTEGER GENERATED BY DEFAULT AS IDENTITY (START
WITH 13763, INCREMENT BY 1) NOT NULL,
                    "MsgListGuid" VARCHAR(22) COLLATE "ANSI" NOT NULL,
                    "MessageGUID" VARCHAR(22) COLLATE "ANSI",
                    "ItemNo" SMALLINT,
                    "JurisCode" VARCHAR(4) COLLATE "ANSI_CI",
                    "CaseNo" VARCHAR(8) COLLATE "ANSI_CI",
                    "CaseName" VARCHAR(75) COLLATE "ANSI_CI",
                    "IsNew" BOOLEAN DEFAULT true,
                    "IsRead" BOOLEAN DEFAULT false,
                    "ProcessedFlag" VARCHAR(1) COLLATE "ANSI",
                    "NumPdfExpected" SMALLINT,
                    "NumPdfRetrieved" SMALLINT,
                    "NumPdfMissed" SMALLINT,
                    "NumPDFSkipped" SMALLINT,
                    "NumErrorsOnPdf" SMALLINT,
                    "MsgState" VARCHAR(5) COLLATE "ANSI",
                    "Subject" VARCHAR(100) COLLATE "ANSI_CI",
                    "SubSubject" CLOB COLLATE "ANSI_CI" COMPRESSION 6,
                    "Date" TIMESTAMP,
                    "EMailAddress" VARCHAR(50) COLLATE "ANSI_CI",
                    "From" VARCHAR(75) COLLATE "ANSI_CI",
                    "DocNo" SMALLINT,
                    "ClaimNo" SMALLINT,
                    "DocketText" CLOB COLLATE "ANSI_CI" COMPRESSION 6,
                    "CredName" CLOB COLLATE "ANSI_CI" COMPRESSION 6,
                    "TotAmtClaimed" FLOAT,
                    "IsOfInterest" BOOLEAN,
                    "NumAutoEvents" SMALLINT,
                    "NumEvents" SMALLINT,
                    "MsgEventsSummary" VARCHAR(5) COLLATE "ANSI",
                    "Forwarded" BOOLEAN,
                    "PreviewNote" CLOB COLLATE "ANSI_CI" COMPRESSION 6,
                    "FolderGuid" VARCHAR(22) COLLATE "ANSI",
                    CONSTRAINT "PrimaryKey" PRIMARY KEY ("PK")
                    )
                    VERSION 1.08
                    UNENCRYPTED
                    INDEX PAGE SIZE 4096
                    BLOB BLOCK SIZE 256
                    MAX ROW BUFFER SIZE 32768
                    MAX INDEX BUFFER SIZE 65536
                    MAX BLOB BUFFER SIZE 32768';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByMessageGUID" ON "IGNMsgList"
                    ("MessageGUID" COLLATE "ANSI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByIsNew" ON "IGNMsgList"
                    ("IsNew")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByIsRead" ON "IGNMsgList"
                    ("IsRead")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByProcessedFlag" ON "IGNMsgList"
                    ("ProcessedFlag" COLLATE "ANSI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByCaseNo" ON "IGNMsgList"
                    ("CaseNo" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "BySubject" ON "IGNMsgList"
                    ("Subject" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByDate" ON "IGNMsgList"
                    ("Date")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByItemNo" ON "IGNMsgList"
                    ("ItemNo")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByCaseName" ON "IGNMsgList"
                    ("CaseName" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByEMailAddress" ON "IGNMsgList"
                    ("EMailAddress" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByMsgState" ON "IGNMsgList"
                    ("MsgState" COLLATE "ANSI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByNormalDisplayOrder" ON "IGNMsgList"
                    ("JurisCode" COLLATE "ANSI", "CaseNo" COLLATE "ANSI",
"Date")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByDateDesc" ON "IGNMsgList"
                    ("Date" DESC)';

  EXECUTE IMMEDIATE 'CREATE TEXT INDEX "Text_DocketText" ON "IGNMsgList"
                    ("DocketText" COLLATE "ANSI_CI")
                    INDEXED WORD LENGTH ''15''
                    WORD GENERATOR "Default"';

  EXECUTE IMMEDIATE 'CREATE TEXT INDEX "Text_Subject" ON "IGNMsgList"
                    ("Subject" COLLATE "ANSI_CI")
                    INDEXED WORD LENGTH ''15''
                    WORD GENERATOR "Default"';

  EXECUTE IMMEDIATE 'CREATE TEXT INDEX "Text_CaseName" ON "IGNMsgList"
                    ("CaseName" COLLATE "ANSI_CI")
                    INDEXED WORD LENGTH ''15''
                    WORD GENERATOR "Default"';

  EXECUTE IMMEDIATE 'CREATE TEXT INDEX "Text_CredName" ON "IGNMsgList"
                    ("CredName" COLLATE "ANSI_CI")
                    INDEXED WORD LENGTH ''15''
                    WORD GENERATOR "Default"';

  EXECUTE IMMEDIATE 'CREATE INDEX "ByJurisCode" ON "IGNMsgList"
                    ("JurisCode" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "byMsgListGuid" ON "IGNMsgList"
                    ("MsgListGuid" COLLATE "ANSI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "byFolderGuid" ON "IGNMsgList"
                    ("FolderGuid" COLLATE "ANSI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "byfolderid" ON "IGNMsgList"
                    ("NumEvents")';

keith


Is there RI from another table using that index or is it used in a function somewhere?

Roy Lambert [Team Elevate]

Keith,

<< I deleted an index called byFolderId then deleted that field.  When I try
to open the table now I get error 401:  the index byFolderId does not exist.
(which is true).  >>

It may be an issue with the EDB Manager.  I'll check it out and make sure
that it is corrected for the next build.

--
Tim Young
Elevate Software
www.elevatesoft.com

No to both.