Home
Manage Your Code
Snippet: to get ther table disk size (ActionScript)
Title: to get ther table disk size Language: ActionScript
Description: to get ther table disk size of all the tables in that specific database in GBs, can be converted to MB by reducing on 1024 division Views: 80
Author: satyakam rai Date Added: 2/3/2012
Copy Code  
Select tablename, sum(currentperm)/1024/1024/1024 as TableSize from dbc.tablesize
where databasename = 'DBNAME'
group by tablename;