View the amount of space each table occupies in the SQL Server database

To create a stored procedure:

CREATE PROCEDURE [dbo].[Sys_viewtablespace] asBEGINSETNOCOUNT on;CREATE TABLE [dbo]. #tableinfo (table name[varchar]( -) COLLATE Chinese_prc_ci_asNULL, number of records[int] NULL, reserve space[varchar]( -) COLLATE Chinese_prc_ci_asNULL, use space[varchar]( -) COLLATE Chinese_prc_ci_asNULL, the index occupies space[varchar]( -) COLLATE Chinese_prc_ci_asNULL, unused space[varchar]( -) COLLATE Chinese_prc_ci_asNULL)Insert  into#tableinfo (table name, number of records, reserved space, use space, index occupy space, unused space)execSp_msforeachtable "execsp_spaceused'?'"Select *  from#tableinfoOrder  byNumber of recordsdescDrop Table#tableinfoEND

When used directly: Exec sys_viewtablespace

View the amount of space each table occupies in the SQL Server database