Hello Ralf, Systemn view INDEXES contains general information (uniqueness, etc) whereas INDEXCOLUMNS contains detailed info on the columns that are indexed.
For more information, look at http://dev.mysql.com/doc/maxdb/en/4b/955163a1572547bf795fa5d876a656/content.htm Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Ralf Becker [mailto:[EMAIL PROTECTED] > Sent: Monday, August 02, 2004 2:01 PM > To: [EMAIL PROTECTED] > Subject: How to retrive the column-names used in an existing index > > > Hi, > > I'm porting the ADOdb PHP database-abstraction layer to > MaxDB, in order > to use MaxDB with eGroupWare (www.egroupware.org) - an OpenSource > groupware suite. > > How can I retrive the names of the columns in an existing index. > > SELECT INDEX_NAME,UNIQUENESS FROM ALL_INDEXES WHERE > TABLE_NAME='$table' > > Gives my all indexes and its uniqueness of a given table. > > Ralf > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
