Post reply

Data Elements Count

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

  • 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

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply