Get all table names and row counts in SQL server
Microsoft SQL Server is a famous relational database management system developed by Microsoft.Learn how to get all table names and row counts in SQL server using Skyvia Query - online SQL query builder
SELECT
SC.Name + '.' + T.Name TableName,
SUM(P.rows) RowCnt
FROM
sys.tables T
INNER JOIN
sys.partitions P ON P.OBJECT_ID = T.OBJECT_ID
INNER JOIN
sys.schemas SC ON T.schema_id = SC.schema_id
WHERE
T.is_ms_shipped = 0 AND
P.index_id IN (1, 0)
GROUP BY
SC.Name, T.Name
ORDER BY
SUM(P.rows) DESC
Run This and Other Queries Online in Skyvia Query
Skyvia Query allows you to run SQL queries against databases and cloud applications from web browser. Access and manage your data from anywhere, build reports, arrange your data in the most informative way and simplify your decision-making process easily!
Key Features
- Ability to use SQL against cloud data
- Visual query builder
- Data export
- Five free queries per day
