Display Row Count for all Tables

  • cadebryant

    Ten Centuries

    Points: 1035

    Comments posted to this topic are about the item Display Row Count for all Tables

  • Sal Young

    SSC-Addicted

    Points: 479

    cadebryant (9/22/2007)


    Comments posted to this topic are about the item Display Row Count for all Tables

    You could also use the system stored procedure sp_spaceused 'YourTableName' .  I actually saved this and other system stored procedures on my "Keyboard Shortcuts" for easy access.

    [font="Verdana"]Sal Young[/font]
    [font="Verdana"]MCITP Database Administrator[/font]

  • sarlar

    SSC Veteran

    Points: 277

    :unsure:This is not an efficient script, it doesn't include tables without clustered indexes(primary key).

  • hxd001_810-512717

    SSC Journeyman

    Points: 86

    This script has a fault,that is,the results don't contain those tables which not exists any indexes.

Viewing 4 posts - 1 through 4 (of 4 total)

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