Home Forums Article Discussions Article Discussions by Author Discuss content posted by Harsha Majety Query to get tables with no clustered indexes RE: 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