How do I find size in KB of particular table

• pmanisekaran

  SSC-Addicted

  Points: 401

  More actions

  May 26, 2003 at 10:14 pm

  #64680

  How do I find size in KB of particular table in a database

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  May 27, 2003 at 12:25 am

  #458561

  Hi pmanisekaran,

  EXEC sp_spaceused '<your_table>'.

  Is also explained in BOL.

  Cheers,

  Frank

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