How do I check the size of an indexed view in SQL Server?

sql-server ssms indexed-view system-stored-procedures
Steven de Salas picture Steven de Salas · May 18, 2011 · Viewed 8.3k times · Source

Its easy to check storage sizes for Tables and Indexes, you can right-click the table object on SSMS explorer and voila, the details appear in a nice popup.

But since Indexed Views are displayed the same as Normal Views, there is no storage information avaiable in SSMS to show me the current size taken up on disk.

enter image description here

Is there an alterate way to calculate the size (say via a system SP or similar method)?

Thanks.

Answer

Martin Smith picture Martin Smith · May 18, 2011 
EXEC sys.sp_spaceused @objname = N'dbo.YourView'

Related questions

How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?

Read More
Insert Data Into Temp Table with Query

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this? Here is an …

Read More
How to see query history in SQL Server Management Studio

Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can you give me any advice on how to see it?

Read More