Hi all,
is it possible to rename a view that has dependent views?
Imagine this:
- Table named tblData
- View named vwData_TB based on table tblData
- View named vwData_RB based on view vwData_TB
I need to make some changes to (recreate) vwData_TB, but I don't want to delete the original until I know the new version is working.1: dependent objects exist: PUBLIC.VWDATA_RB in statement
[ALTER TABLE "VWDATA_TB" RENAME TO "DELETE_VWDATA_TB"]
Thanks for any help anyone can provide,
CTB