alter_view - phpMan

ALTER VIEW()                     SQL Commands                     ALTER VIEW()



NAME
       ALTER VIEW - change the definition of a view


SYNOPSIS
       ALTER VIEW name RENAME TO newname


DESCRIPTION
       ALTER  VIEW  changes  the definition of a view.  The only currently available func-
       tionality is to rename the view.  To execute this command you must be the owner  of
       the view.

PARAMETERS
       name   The name (optionally schema-qualified) of an existing view.

       newname
              The new name of the view.

NOTES
       Some variants of ALTER TABLE can be used with views as well; for example, to rename
       a view it is also possible to use ALTER TABLE RENAME. To change the schema or owner
       of a view, you currently must use ALTER TABLE.

EXAMPLES
       To rename the view foo to bar:

       ALTER VIEW foo RENAME TO bar;


COMPATIBILITY
       ALTER VIEW is a PostgreSQL extension of the SQL standard.

SEE ALSO
       CREATE VIEW [create_view(7)], DROP VIEW [drop_view(l)]



SQL - Language Statements         2009-03-12                      ALTER VIEW()

Generated by $Id: phpMan.php,v 4.54 2007/08/21 09:05:22 chedong Exp $ Author: Che Dong
On Apache/2.2.3 (Red Hat)
Under GNU General Public License
2009-12-24 02:08 @127.0.0.1 CrawledBy CCBot/1.0 (+http://www.commoncrawl.org/bot.html)