Index checking from SQL query

[LesStockton]

Is there a SQL query to check to see if an index (by name) exists on a table?
I have this for SQL Server and for Oracle, and need to be able to query to see if an index exists before I try to create it. In some cases, I just need to be able to programmatically check to see if the index, by name, is there.

 

[r937]

SHOW INDEX FROM tablename

r937.com | rudy.ca

 

[LesStockton]

This wont work.
The SHOW INDEX command isn't something that I can send through ADO from my program. I need something that I can programmatically use to check, and in addition, the SHOW INDEX will not check for a specific index.
Now, if I can get a recordset back from the SHOW INDEX command, then I could loop through and see if the index exists. I'll try that unless someone has a better query, like going through the schema.

 

[r937]

Now, if I can get a recordset back from the SHOW INDEX command, then I could loop through and see if the index exists.

my advice is, please try it, and let us know what you get

r937.com | rudy.ca

 

[LesStockton]

I'll do that. Thanx.
I probably wont get to it until Monday, but thanx.

 

[r937]

since you're on version 5, you could also query the information_schema.statistics table

r937.com | rudy.ca