Flaw in dbschema

I don't know why but when I count number of indexes generated by dbschema for specific "database and owner" is different than the number I get when I look at sysindexes table for specific "database and owner". All I can tell is they are 3 idexes off and all 3 indexes name that wasn't generated by dbschema starts with number. Could you please tell me why or how can I get these indexes.

Generated indices for constraints are numbered and will not show up in dbschema output as 'create index'. Instead they will show up as constraints. Genrally their names start with space, followed by tabid, underscore, and I forget the rest. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of mohitanchlia@gmail.com Sent: Monday, June 18, 2007 8:26 PM To: informix-list@iiug.org Subject: Flaw in dbschema I don't know why but when I count number of indexes generated by dbschema for specific "database and owner" is different than the number I get when I look at sysindexes table for specific "database and owner". All I can tell is they are 3 idexes off and all 3 indexes name that wasn't generated by dbschema starts with number. Could you please tell me why or how can I get these indexes. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list