code bits

code bits from my daily programming experiences in #c#,#sql,#.net,#asp.net,#hadoop,#PIG

Friday, June 29, 2012

Check INDEX exists and DROP index SQL Server

declare @index_name varchar(50)

set @index_name = (select name from sys.indexes where name='index_name' AND object_id = object_id('table_name'))

if(@index_name) is not null

begin 
     drop index table_name.index_name
end
Posted by Virtuoso at 7:30 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: index exists
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Blog Archive

  • ►  2016 (5)
    • ►  July (1)
    • ►  March (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2015 (20)
    • ►  December (2)
    • ►  November (1)
    • ►  October (2)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ►  June (3)
    • ►  May (4)
    • ►  March (2)
    • ►  January (1)
  • ►  2014 (21)
    • ►  December (4)
    • ►  November (3)
    • ►  October (5)
    • ►  August (1)
    • ►  July (2)
    • ►  June (1)
    • ►  April (5)
  • ►  2013 (24)
    • ►  December (2)
    • ►  November (2)
    • ►  October (1)
    • ►  August (3)
    • ►  July (2)
    • ►  June (1)
    • ►  May (1)
    • ►  April (1)
    • ►  March (6)
    • ►  February (1)
    • ►  January (4)
  • ▼  2012 (61)
    • ►  November (7)
    • ►  October (3)
    • ►  September (2)
    • ►  August (12)
    • ►  July (36)
    • ▼  June (1)
      • Check INDEX exists and DROP index SQL Server
  • ►  2007 (5)
    • ►  September (3)
    • ►  June (2)
Simple theme. Powered by Blogger.