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...
Showing posts with label Table. Show all posts
Showing posts with label Table. Show all posts
Tuesday, 30 October 2018
Wednesday, 8 March 2017
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) ...