Advanced Search

Return to Snippet

Revision: 51005
at September 11, 2011 02:10 by plugables
Initial Code 
CREATE TABLE #tmpOutput (TableName VARCHAR(300), TableRowCount INT)
EXEC dbo.sp_MSForEachTable 'INSERT INTO #tmpOutput(TableName, TableRowCount) SELECT ''?'', COUNT(*) FROM ?'
SELECT TableName, TableRowCount
FROM #tmpOutput
ORDER BY TableRowCount DESC
DROP TABLE #tmpOutput
Initial URL 









Initial Description





Get number of rows in each table of the database (MSSQL)









Initial Title





Get number of rows in each table of the database









Initial Tags














Initial Language





SQL