Query to get tables with no clustered indexes

• harsha.majety

  SSCommitted

  Points: 1537

  More actions

  February 12, 2011 at 7:52 pm

  #388843

  Comments posted to this topic are about the item Query to get tables with no clustered indexes

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  May 4, 2011 at 11:58 pm

  #1320215

  Dear Harsha,

  I am not getting OBJECTPROPERTY(object_id,'TableHasClustIndex') column when I checked only SELECT * FROM sys.tables.

  How Where condition is not giving error or to which table OBJECTPROPERTY column is belonging.:-)

  Thanks

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 17, 2016 at 6:51 am

  #1879502

  Thanks for the script.