Database count using system tables

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

  • 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?

  • 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