Получить список индексов таблицы
Falk0ner, вс, 06/07/2008 - 15:34.
Получить список индексов таблицы
--©Drkb v.3(2007): <a href="http://www.drkb.ru
SELECT" title="www.drkb.ru
SELECT">www.drkb.ru
SELECT</a> i.name AS index_name
FROM sysobjects o
INNER JOIN sysindexes i ON o.id = i.id
WHERE o.xtype = 'U' AND i.indid > 0 AND
i.indid < 255 AND INDEXPROPERTY(i.id, i.name, 'isStatistics') = 0 AND
o.name = @TableName
ORDER BY i.indid
SELECT" title="www.drkb.ru
SELECT">www.drkb.ru
SELECT</a> i.name AS index_name
FROM sysobjects o
INNER JOIN sysindexes i ON o.id = i.id
WHERE o.xtype = 'U' AND i.indid > 0 AND
i.indid < 255 AND INDEXPROPERTY(i.id, i.name, 'isStatistics') = 0 AND
o.name = @TableName
ORDER BY i.indid
Автор: Vit (www.delphist.com, www.drkb.ru, www.unihighlighter.com, www.nevzorov.org)
Отправить комментарий