how know the table size ?

Database

how know the table size ?

how know the table size ?

2 REPLIES

Re: how know the table size ?

sel * from dbc.tablesize where tablename='employee' and databasename='xxxx'

Re: how know the table size ?

Just to add more to the above Query -

Select Sum(Currentperm), vproc

from DBC.Tablesize  

where databasename ='abc'

and tablename ='pqr'

Group by Vproc;