Table Sizes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

-- DB size.
	EXEC sp_spaceused

	-- Table row counts and sizes.
	CREATE TABLE #t 
	( 
		[name] NVARCHAR(128),
		[rows] CHAR(11),
		reserved VARCHAR(18), 
		data VARCHAR(18), 
		index_size VARCHAR(18),
		unused VARCHAR(18)
	) 

	INSERT #t EXEC sp_msForEachTable 'EXEC sp_spaceused ''?''' 

	SELECT *
	FROM   #t
	 

	-- # of rows.
	SELECT SUM(CAST([rows] AS int)) AS [rows]
	FROM   #t
	 
	DROP TABLE #t

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results