index checking?

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.

Contributor

Replies

View

HockeyFan

Newbie Poster

1 post since Dec 2005

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead