Table's size

• Bohy

  Newbie

  Points: 1

  More actions

  October 2, 2002 at 12:28 am

  #58540

  There are some ways to know size of

  database, but how about table?

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  October 2, 2002 at 1:30 am

  #437603

  EXEC sp_spaceused 'TABLENAME'

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• J.Mac

  Mr or Mrs. 500

  Points: 508

  More actions

  October 2, 2002 at 3:30 am

  #437607

  You can also use directly the system table if you want integer into a T-SQL statement

  SELECT

  SD.NAME,

  SF.*

  FROM

  MASTER..SYSDATABASES SD, MASTER..SYSALTFILES SF

  WHERE SF.DBID = SD.DBID

  JMackels Developer / DBA