SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Harsha Majety / Query to get tables with no clustered indexes / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 08:15:16 GMT20RE: Query to get tables with no clustered indexeshttp://www.sqlservercentral.com/Forums/Topic1063081-2846-1.aspxDear 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.:-)Wed, 04 May 2011 23:58:02 GMTforsqlserverQuery to get tables with no clustered indexeshttp://www.sqlservercentral.com/Forums/Topic1063081-2846-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Indexing/72315/">Query to get tables with no clustered indexes</A>[/B]Sat, 12 Feb 2011 19:52:12 GMTharsha.majety