Declare @tableRowCount Table
(
TableName Varchar(300),
RowCnt INT
)
Insert into @tableRowCount
EXEC sp_msforeachtable 'select parsename(''?'',1), count(*) from ?'
select * from @tableRowCount
where RowCnt! = 0 ---(rowcnt=0 is not having any records)
order by RowCnt
Subscribe to:
Post Comments (Atom)
-
---Fibonacci numbers declare @fib table(fib_id bigint,fib_val bigint) declare @current_val bigint,@previous_val bigint,@new_val bigint in...
-
Database is a collection of objects such as table, view, stored procedure, function, trigger, etc. In MS SQL Server, two types of databa...
-
Created a table called SegmentDetails. It has 2 columns Segment and Details. Segment contains the category name while Details contains the ...
No comments:
Post a Comment