Thursday, September 9, 2010

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'

No comments:

Post a Comment