Hi Ian,
mysql> SHOW INDEX FROM tbl_name; Best regards Nils Valentin Tokyo/Japan 2003年 8月 14日 木曜日 12:13、Ian Collins さんは書きました: > Is there any way of determining the existence of an index? > > I have a colleague messing about porting an application from MS > SQLServer to MySQL 5 (compiled from the source). > This application uses (whether it be good or bad) stored procedures > heavily. > > We just wanted to check to see if an index existed as part of a stored > procedure. > The only way I can see to do it is to use "show index from table", but > that gives all indexes and then parsing the results. > > We are after a more efficient way (like the sqlserver query "select * > from sysindexes where name=.....") > > -- > > Many Regards, > Ian Collins > System Manager > KIWIPLAN NZ Ltd. > ================ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]