Получить список индексов таблицы

Previous  Top  Next

    
 

 

 

Code:

--©Drkb v.3(2007): www.drkb.ru

 

SELECT 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

 

©Drkb::02805

Автор: Vit (www.delphist.com, www.drkb.ru, www.unihighlighter.com, www.nevzorov.org)