Bhutan ICT
E-Learning, Web Design, Linux, PHP, Wordpress, Visual Studio .NET, Windows, SQL Server, ASP.NET, C#
Pages
Home
About
Privacy Policy
Aug 8, 2012
Display size of tables in SQL Server
A very simple query but yet so useful in getting the information of tables size in your database:
USE [yourdbname]
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment