Data Elements Count

• ATLDBA

  SSC Veteran

  Points: 227

  More actions

  March 11, 2004 at 7:11 am

  #107329

  DBAs,

   

  What is the best way to determine the total number of data elements/fields in a SQL Server database?  Thanks!

  
  Carpe diem!

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  March 11, 2004 at 7:30 am

  #498290

  If you mean colums across all user tables and views:

  SELECT COUNT(*)

  FROM INFORMATION_SCHEMA.COLUMNS

  
  
  --Jonathan

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  March 11, 2004 at 7:41 am

  #498294

  Please avoid cross posts. It's really hard to follow.

  So, where should we continue?

  Here or here?

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]