Get row counts and space used for every table

,

Use the sp_MSforeachtable stored procedure to run the sp_spaceused stored procedure for every table in a database

exec sp_MSforeachtable "exec sp_spaceused '?'"

Rate

Share

Share

Rate