| Author: Ravindra Kumar Singh 03 Jul 2008 | Member Level: Gold | Rating:  Points: 2 |
Hi,
Use this query:
select count(*) from sysobjects where xtype = 'U'
where U is User Table
and if you want system table also then use this query
select count(*) from sysobjects where xtype = 'U' or xtype='S'
where S is system table
|
| Author: Bunty 03 Jul 2008 | Member Level: Diamond | Rating: Points: 3 |
Hi,
Please select the appropriate database and then execute the below query to get the required result,
Select count(*) from sysobjects
Where xtype='u'
Thanks and Regards
S.S.Bajoria
Thanks & Regards
S.S.Bajoria
|