Script for finding All Tables count in User Defined Databases in Sq Server 2k,2k5,2k8,2k12 etc


Hi All,

Below is the script for the All Table count for instance.

We have excluded the system databases

DECLARE @Sql NVARCHAR(2000)
DECLARE @Dbname NVARCHAR(200)
DECLARE @Name VARCHAR(150)

Leave a Reply

Create your own website, free on WordPress.com.Create your own website.
Start free