Thank you, describe is just what I want. the rest two I'll remember, they will be handy when I need them.
Lei Bryan Pendleton wrote: > >> 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 > > > > > -- View this message in context: http://www.nabble.com/How-to-check-existing-column-size--tp23565303p23569304.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
