How to Count the number of tables in sql server database

[sujitopics]

Hai

How to count the number of tables existed in database

pl send the sql query to count the number of tables existed in the database in sqlserver 2000 environment

thankyou very much

yours suji

 

[tlbroadbent]

Select Count(*) As DBCount
From master.dbo.sysdatabases Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[moonshadow]

select count(*) from INFORMATION_SCHEMA.TABLES where table_type='BASE TABLE'

This returns the number of tables in the current database for which the user has permissions.

 

[tlbroadbent]

Moonshadow,

Thanks for catching my error. For some reason I read "count databases." :~/ Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[moonshadow]

If only someone would catch all my errors !!