Unanswered: checking if a table has index on it in ms sql server7
I am using MS sql 7 as database with ASP as front end. in the front end i want to check if a particular table has an index on it. if yes i want to drop index, truncate the table, insert new values into the table and recreate index. this i am doing to make inserting values faster.
in case the front end is being run for first time ever.index would not be present. so if i do drop index in front end script i would get error.
so in this case drop index should not be done and directly table shd be truncated(step 2)
so how can i check if this particular table has an index already created.. any sql query that can send a reply of presence or absence of index in sql server7? any thing related to sysindexes?