Hi,
Is 'Select <col> as from <table>' , what you are looking for.
The schema: -------------- ij> select * from atab; ID |COL1|COL2 --------------------- 1 |CA |MI
1 row selected
Using the 'select as' ------------------------
ij> select id as IDENT_NUM from atab; IDENT_NUM ----------- 1
1 row selected
-Rajesh
Jason Palmatier wrote:
Does Derby support anything like LABEL ON which allows you to set the label (i.e. a displayable name) for a column after a table is created? I checked the reference manual and it doesn't seem to but I wanted to ask here to be sure.
Thanks, Jason
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
