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