请问如何获知一个表里的索引是否存在呢?不存在则创建?
thanks

------解决方案--------------------
IF EXISTS (SELECT name FROM sysindexes
WHERE name = 'indexname ')
DROP INDEX tablename.indexname

------解决方案--------------------
IF NOT EXISTS (SELECT name FROM sysindexes
WHERE name = 'indexname ')
CREATE INDEX indexname ON tablename(col)