Results 1 to 3 of 3

Thread: Table size

  1. #1
    Join Date
    Oct 2004
    Posts
    91

    Unanswered: Table size

    Hi Everyone -

    I have to get the size of each table in a database...

    I understand the varchar issue (variable width)
    but is there a way to see what the max footprint
    of a table will be with one record filled to its maximum
    value of fields???

    thanks
    tony

  2. #2
    Join Date
    Aug 2004
    Posts
    38
    Tony,

    Assuming this is ase, you can use sp_estspace to do this. Syntax should be something along the lines of:

    sp_estspace mytab,1,null,"col1,col2,col3"

    where 1 is for one record and the column list is the names of the varchar columns that you want estimated at their maximum sizes.

  3. #3
    Join Date
    Oct 2004
    Posts
    91

    ooops

    No - sorry - this is ASA 7.0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •