Проверить существует ли индекс |
Previous Top Next |
Code: |
-- ©Drkb v.3(2007): www.drkb.ru
if exists( SELECT * 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, @IndexName, 'isStatistics') = 0 AND o.name = @TableName) Set @exists=1 else Set @exists=0 |
©Drkb::02807
Автор: Vit (www.delphist.com, www.drkb.ru, www.unihighlighter.com, www.nevzorov.org)