Re: Index existence

2003-08-14 Thread Nils Valentin
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 t

Index existence

2003-08-14 Thread 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 exis