Rename View

Database
Enthusiast

Rename View

Is It possible to rename the VIEW itself without creating the new one?

2 REPLIES
Enthusiast

Re: Rename View

Yes.
Be careful though; the name change is not carried through completely.
Consider the following:

Replace View Test_Y1 As Select Current_Date As RunDate;
Replace View Test_Y2 As Select * From Test_Y1;
Rename View TesT_Y1 As Test_Y3;

Test_Y3 works correctly.
Test_Y2 no longer works - Test_Y1 cannot be found.
Enthusiast

Re: Rename View

Thanks.