0 Replies Latest reply: Aug 24, 2004 8:45 AM by 4790 RSS

    what sql can get the columns size of one designed table?

    4790
      I have to optimize hundreds table but tired to verify the columns size between the data dictionary and the "desc" output, so that I code one program to do thus sterld jobs, but I know nothing about how to query the size of the columns one designated table such as "desc tablename",which can be got from the resultset such like normal name-value pair cursor. who can do me the favor?

      thanks in advance

      Fredeick