This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 在SQL SERVER 上用何命令得到某个数据库表的大小？HOW TO get the size of a table in a Sql server.
-yfy_ca(yfy);
2001-9-18
{48}
(#204196@0)
-
What I found for SQL Server online help....
-luoboyang(萝卜秧);
2001-9-18
{3053}
(#204216@0)
-
And you can use 'sp_help tablename' to get all the info. to calculate the size.
-luoboyang(萝卜秧);
2001-9-18
(#204221@0)
-
sp_spaceused tablename
-blackswan(uglyduck);
2001-9-18
(#204243@0)
-
我其实有些困惑，他是要table中所有fields的size,还是整个表所占用的空间？
-luoboyang(萝卜秧);
2001-9-18
(#204272@0)
-
I think it is table size according to his words.
-blackswan(uglyduck);
2001-9-18
(#204326@0)
-
thank u
-yfy_ca(yfy);
2001-9-24
(#208917@0)
-
there is an easy way to check it.1. If in sql 6.5, select the table , right click mouse and select "indexes"
2. If in sql 7.0, select the database, from the menu->view, select "Taskpad", then u will find the information for all the talbes(including the size of the table) in this database
-yangn(Raymond);
2001-10-3
{260}
(#215536@0)