Counting Data Elements

• ATLDBA

  SSC Veteran

  Points: 277

  More actions

  March 11, 2004 at 7:19 am

  #84714

   DBAs,

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

  
  Carpe diem!

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  March 11, 2004 at 7:37 am

  #498293

  I would run a count() on some INFORMATION_SCHEMA stuff.

  

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