[RBASE-L] - Re: Alter command to remove Compute

[Albert Berry]

If the column appears in more than one table, you will need to rename 
the column when you change the definition. For example if you have a 
computed column in a table such as this:
R>create temp table ttab (invvalue currency, tax1 currency, tax2 
currency, grandtotal = (invvalue + tax1 + tax2) currency)

You could change the grandtotal column to a normal currency column with 
this command

alter table ttab alter column grandtotal currency.

Albert

Charles Parks wrote:
Is there an alter command to remove a compute option from a column?