IF EXISTS (SELECT * FROM sys.indexes WHERE name='Index_Name'
AND object_id = OBJECT_ID('[SchmaName].[TableName]'))
begin
DROP INDEX [Index_Name] ON [SchmaName].[TableName];
end
Showing posts with label Index. Show all posts
Showing posts with label Index. Show all posts
Saturday, July 9, 2016
Check for Index on table
Thursday, October 3, 2013
Create Date of SQL Server Index
select crdate, i.name, object_name(o.id)
from sysindexes i join sysobjects o ON o.id = i.id
where i.name IN ('ndx_move','ndx_2')
order by crdate desc
from sysindexes i join sysobjects o ON o.id = i.id
where i.name IN ('ndx_move','ndx_2')
order by crdate desc
Subscribe to:
Posts (Atom)