Loading ...

Count Number of Tables/Columns in Database | CodeAsp.Net

Count Number of Tables/Columns in Database

 /5
0 (0votes)

Many times we want to know How many Tables we using in our Database.
Here I have written the query to find the total number of tables/columns used in Database.

SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE = 'U'

Here U is used for Tables.
This Query return TotalNumber of Tables present in the Database.

If We want to Know the total column name in whole Database then used following Query

SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS

This Query returns the total number of tables present in the Database.

If We want to know all the  column names,then use the following query:

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS


Hope It will Help to all.

 

 

Comments (1)

   
ajit
nice post vijendra..
10/10/2012
 · 
by
  • :*
  • :*
  • :
 *

Top Posts