db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: How to check existing column size?
Date Fri, 15 May 2009 18:51:49 GMT
> 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




Mime
View raw message