Latest Activity

code

Rename columns of derived and interface views

Hi, Please advise on using alter statement to rename columns of derived views and interface views. We are using this command, alter view dv_view ( alter column old_coiumn rename new_column ) Error - Syntax error: Exception parsing query near 'rename'...

derived view column rename

code

how to rename a derived view column name

ALTER VIEW xyz( ALTER COLUMN abc RENAME column mnn); how can we rename a derived view column name

derived view column rename