Home » RDBMS Server » Server Administration » alter view
alter view [message #374796] Tue, 03 July 2001 01:41 Go to next message
Konstantin
Messages: 6
Registered: June 2001
Junior Member
How can I add a column to an existing view?

Thanks in advance.

Report message to a moderator

Re: alter view [message #374797 is a reply to message #374796] Tue, 03 July 2001 05:26 Go to previous message
kavithask
Messages: 34
Registered: March 2001
Location: London
Member
Hi,

You would need to recreated the view for it to fetch extra columns. Create the view using the command create or replace view and specify the changed select statement.

HTH
Kavitha

Report message to a moderator

Previous Topic: Copy Data……….How to do???
Next Topic: Invalid Views
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 04:17:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.