Sybase ASE 入門 DBの容量を確認する

sp_spaceused を使います

sp_spaceused

 database_name                                        database_size             
 ---------------------------------------------------- ----------------------------------------------------
 ase1                                                 6.0 MB                    

(1 row affected)
 reserved                         data                     index_size                               unused
 -------------------------------- ------------------------ ---------------------------------------- ----------------------------
 4572 KB                          764 KB                   376 KB                                   3048 KB
(return status = 0)

第1引数でテーブルを指定できる

"sp_spaceused test_table"
 name                                     rowtotal                         reserved                         data             index_size                               unused
 ---------------------------------------- -------------------------------- -------------------------------- ---------------- ---------------------------------------- ------------------------
 test_table                               0                                92 KB                            4 KB             8 KB                                     68 KB

(1 row affected)