Following query displays the total number of rows corresponding to each table in the database.
select o.name 'Table Name',rowcnt 'Total Number of Rows' from sysindexes i
inner join sysobjects o on i.id=o.id
where indid<2
and o.xtype='U'
Order by 'Total Number of Rows' desc
Result of above query is sorted by the row count of table in descending order.
Output
Do not use NOT IN clause in sub query, instead of this use LEFT OUTER JOIN shown in below example query. This will reduce the execution time and improves the performance. To know more details with exa
When you create any new object(table, stored procedure, view,...etc.) in database then same object name will be stored in system table Sysobjects. Following query returns all the object names along wi
Sometimes you get a scenario where you know the column name but don't remember which table it belongs to. Following query will search for a given column name in database schema and returns all objects