请问如何获知一个表里的索引是否存在呢?不存在则创建?
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)