To fetch tables having records in db

select * from sys.objects where object_id in (
select id from sysindexes where indid <2>0 )
and type ='U'