Select Rows as No_of_Rows from SysIndexesWhere Id = OBJECT_ID('Your Table Name') andindid<2;
Login to post response