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

By Chaitanya Talasila on

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)

Posted in: sql server

Leave a comment

Design a site like this with WordPress.com
Get started