Post reply

Database count using system tables

  • September 23, 2007 at 2:26 am

    #181176

    Comments posted to this topic are about the item Database count using system tables

  • November 10, 2009 at 7:56 am

    #1077281

    the query provided by you is not showing database count, it can be used for table count, how we can get the database count in the sql server? is there any way?

  • November 10, 2009 at 8:05 am

    #1077289

    gururajkamath (11/10/2009)

    the query provided by you is not showing database count, it can be used for table count, how we can get the database count in the sql server? is there any way?

    The query provided by Jorge will give you record count for all tables in a database.

    To list out databases, you can query sysdatabases table

    select * from sysdatabases will run for both 2000 and 2005

    OR

    select * from sys.databasesspecific to sql server 2005


    Pradeep Singh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply