db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From LeiLi <leile...@hotmail.com>
Subject Re: How to check existing column size?
Date Sat, 16 May 2009 00:48:43 GMT

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.


Mime
View raw message