Rename View

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Rename View

Rate Topic

Display Mode

Topic Options

Author

Message

Rajasan77

Posted 10/12/2009 11:02:14 AM

Junior Member

Group: Forum Members
Last Login: 11/18/2009 10:51:34 AM
Posts: 10, Visits: 36

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

Post #17078

jimm

Posted 10/12/2009 2:49:29 PM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111, Visits: 263

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.

Post #17079

Rajasan77

Posted 10/12/2009 4:35:07 PM

Junior Member

Group: Forum Members
Last Login: 11/18/2009 10:51:34 AM
Posts: 10, Visits: 36

Thanks.

Post #17080

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 6:09pm