Re: How to check existing column size?

[Bryan Pendleton]

so how can I know what's the current size of the column "HISTORY" and how

In ij, you can say 'describe mytable', and it will print a nice display.

Alternatively, you can say

   select * from sys.syscolumns where columnname='HISTORY'

Yet a 3rd way would be to call DatabaseMetaData.getColumns().

For simple interactive use, the 'describe' command should be the easiest.

thanks,

bryan