Results 1 to 3 of 3

Thread: row count and table size on Sybase 11.5

  1. #1
    PB Guest

    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.

  2. #2
    markcurtis Guest

    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.

  3. #3
    kumar Guest

    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&#39
    //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
  •