Azure SQL - List all tables and row-count Apr 10, 2017 • weznagwama Quick and dirty query to list all tables and row-count: select t.name ,s.row_count from sys.tables t join sys.dm\_db\_partition_stats s ON t.object\_id = s.object\_id and s.index_id = 1