why two indexes have the same name in a database?

Posted in 2003

YUAN QUAN — Tue, 22 Jul 2003 08:59:53 — source: IIUG Forums & Mailing Lists

I found the name of two indexes is same in a database! execute the following sql: SELECT T.tabname, I.idxname, I.owner FROM systables T, sysindexes I WHERE I.tabid = T.tabid AND I.idxname="idx_name" output two row! but the output of "dbschema -d dbname -t tabname" have any index information!

↪ replying to YUAN QUAN

rkusenet — Tue, 22 Jul 2003 14:37:22 — source: IIUG Forums & Mailing Lists

try this SELECT unique T.tabname, I.idxname, I.owner FROM systables T, sysindexes I WHERE I.tabid = T.tabid AND I.idxname="idx_name" does it still show 2 rows. ----- Original Message ----- > From: "YUAN QUAN" <yuanjoin@163.net> > To: <ids@iiug.org> > Sent: July 22, 2003 04:59 > Subject: why two indexes have the same name in a database? [1580] > > > > > > I found the name of two indexes is same in a database! > > > > execute the following sql: > > > > SELECT T.tabname, I.idxname, I.owner FROM systables T, sysindexes I > > WHERE I.tabid = T.tabid AND I.idxname="idx_name"> > > > output two row! > > > > but the output of "dbschema -d dbname -t tabname" have any index > information! > > > > > > > > > > > > > > >