| Author: Dharmaraj 03 Jul 2008 | Member Level: Diamond | Rating:  Points: 1 |
Hi,
“SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N’myTable’;”
|
| Author: Abhijeet Kumar 03 Jul 2008 | Member Level: Gold | Rating: Points: 1 |
select count(*) from sysobjects where xtype = 'U'
should work
|
| Author: Satyanarayan SushilKumar Bajoria 03 Jul 2008 | Member Level: Gold | 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
|