-
row count and table size on Sybase 11.5
Hi Guys --
I'll really appreciate if someone could point me in the right direction to find where Sybase 11.5 stores information related to...
... the Quantity of rows a table has,
... the current Size of a specific table.
Thank you in advance.
-
row count and table size on Sybase 11.5 (reply)
Select count (*) from tablename will show the amount of rows in your table
Current size of table I wasn't aware you could find table sizes thought the segments were just extended each time a table was added.
------------
PB at 5/22/2002 9:41:42 AM
Hi Guys --
I'll really appreciate if someone could point me in the right direction to find where Sybase 11.5 stores information related to...
... the Quantity of rows a table has,
... the current Size of a specific table.
Thank you in advance.
-
row count and table size on Sybase 11.5 (reply)
Please find the query to get rows count for all the tables in a database
//select Table_Name=object_name(id),
//"Rows"=convert(int,sum(rowcnt(doampg))) ,
//"ReservedKB"=sum(reserved_pgs(id,doampg))* 2+ sum(reserved_pgs(id,ioampg))*2,
//"Data"=sum(data_pgs(id,doampg))*2 ,
//"Index"=sum(data_pgs(id,ioampg))*2
//from sysindexes
//where id in (select id from sysobjects where type='U'
//group by object_name(id);
------------
PB at 5/22/2002 9:41:42 AM
Hi Guys --
I'll really appreciate if someone could point me in the right direction to find where Sybase 11.5 stores information related to...
... the Quantity of rows a table has,
... the current Size of a specific table.
Thank you in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|