alter view

From: Brian Forster <bforster_at_indol.com>
Date: Thu, 30 Sep 1999 11:38:34 -0500
Message-ID: <mqMI3.3352$E6.20457363@news.netdirect.net>

Quick question from a beginner:

What is the syntax of alter view? I am trying to change an existing view but it doesn't like the syntax-- I did it just like create view

alter view "viewname" as ...

The references I've tried say it is alter view viewname compile--

Bottom line to I need to drop a view and recreate it each time or is there an alter view statement that lets that view be updated.

Thanks in advance

Brian Forster
Thomson Indiana
Application Support Received on Thu Sep 30 1999 - 11:38:34 CDT