Query to Find Row and Index Count of Database Tables

Above script returns three important details about all the tables of the database.

1) No of NonClustered Index

2) No of the Rows in the Table

3) Table Clustered Index Property (Heap or Clustered Index)