Archive for January, 2010

Mssql tables count

Friday, January 8th, 2010

Count sql tables in a db:

use <dbname>

select count(*) from sysobjects where xtype = ‘U’
go

Posted in Uncategorized | 2 Comments »