how to find particular table has no records

Hi,

For how to find particular table has no records, you can use the following query

select count(*) from tablename

For how to find particular column of table has no values, use the following query

select count(columnname) from tablename where columnname is not null and columnname <> ''


I hope, this will help you.

Thanks & Regards,

Shailesh

Vanchi050585, if this helps please login to Mark As Answer. | Alert Moderator

thanks

Thanks
tvn

Vanchi050585, if this helps please login to Mark As Answer. | Alert Moderator

Hi

To findout in all tables in current database.

1. To findout what are all the table(s) doesn't have Record(s) in current Database.

SELECT O.[NAME] 'Table Name' FROM SYS.SYSINDEXES I JOIN SYS.OBJECTS O
ON(I.id = O.[object_id])
WHERE O.[TYPE] = 'U'
GROUP BY O.[NAME]
HAVING SUM(I.[ROWS]) =0
ORDER BY O.[NAME]

2. To findout what are all the columns in all table is not possible with direct way. (You need some workarround here).

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Vanchi050585, if this helps please login to Mark As Answer. | Alert Moderator

very thankful to updating the knowledge.

Thanks & Regards,

Shailesh

Vanchi050585, if this helps please login to Mark As Answer. | Alert Moderator