Post reply

To know the size of a column...Help

  • October 8, 2004 at 5:52 am

    #162302

    Hi,

    Could u pls tell me how can i get the total size of a column in my table ?

    ex. Table Document ( col1, col2)

    i need to know the total size of col1...

    tks

  • October 8, 2004 at 7:23 am

    #525938

    exec sp_help tablename

  • October 11, 2004 at 6:35 am

    #526130

    For detailed informations on select cluause you can use a syscolumns together as sysobjects.

    Lets try.

     

     

     


    Hildevan O Bezerra

  • October 11, 2004 at 3:07 pm

    #526252

    Depends on what you are after.

    select datalength(col1) from document

    Will return the actual length in bytes of each individual row.

    select sum(datalength(col1)) from document

    Will return the total bytes used by that column in all rows.

    select col_length('document', 'col1')

    Will return the defined length for the column.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply