column size

• Zeal-DBA

  SSCarpal Tunnel

  Points: 4332

  More actions

  July 26, 2010 at 6:39 am

  #221800

  hello experts,

  i have a table, size around 20 gb, it has a image column named candidate_resumes, i want to separate this column from the table bcuse it has bigger sizecomplete word for pdf file, how wud i knw the column total size or size of data column holds???

  pls help

• Henry Treftz

  SSCarpal Tunnel

  Points: 4207

  More actions

  July 29, 2010 at 7:13 pm

  #1200093

  select datalength(column_name) from Table