Get all Tables rows count in a database

Here is T-SQL Statment;

Select 'TabloAdi_TableName' , B.rowcnt 'SatirSayisi_RowCount' from sysobjects A, sysindexes B where and A.type = 'u' and indid <2 order by TableName

good luck,


Popular posts from this blog

Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded. Dynamics CRM 365 Engine version 9 - CRM User creation error

Exception caught instantiating TERADATA report server extension SQL Reporting Services

Could not load file or assembly 'System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified at Configuration class initiation in