List of Tables with Row count

By using sys.tables and sys.partitions we can find a list of database tables with number records(rows) in a table.

Query :

SELECT DISTINCT t.NAME AS TableName,
                p.rows AS RowCounts
FROM sys.tables t
INNER JOIN sys.partitions p ON t.object_id = p.OBJECT_ID
ORDER BY t.Name

Read More

Filter or Search SQL table using SQL Query

In this article, I will explain how to filter table with containing text in SQL server database using SQL query.  

To filter all table which contains given text in SQL server we need to write query using SYS.TABLES table.

SQL Query :

DECLARE @Parameter VARCHAR(100)      

SET @Parameter = 'employee'

SELECT * FROM SYS.TABLES      

WHERE NAME LIKE '%'+ @PARAMETER +'%'      

ORDER BY MODIFY_DATE DESC

Read More