Drop Index, but name is NULL

• mattyk6

  Ten Centuries

  Points: 1152

  More actions

  March 22, 2006 at 10:26 am

  #189915

  I need to drop an index on a table, but the index name is NULL.

  When I run this stmt, it appears:

  select * from sysindexes where id = 750625717 and name is null

  The syntax I have found to drop an index is:

  drop index tablename.indexname

  Any suggestions?

  TIA

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 27, 2006 at 12:26 pm

  #628994

  That simply implies that the index does not exists for that ID or that it si not a 'real'  index.

   

  Where did you get that ID from ?

   

   

  
  * Noel

• skeane

  SSC Eights!

  Points: 887

  More actions

  March 28, 2006 at 9:13 am

  #629215

  sysindexes.name is not a nullable column, so this seems fishy. What is the indid of the index in question? What does this give you:

  select 'drop index [' + object_name(id) + '].[' + name + ']' from sysindexes where id = 750625717