drop_view man page on BSDOS

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDOS logo
[printable version]

DROP VIEW()			 SQL Commands			   DROP VIEW()

NAME
       DROP VIEW - Removes existing views from a database

SYNOPSIS
       DROP VIEW name [, ...]

   INPUTS
       name   The name of an existing view.

   OUTPUTS
       DROP   The message returned if the command is successful.

       ERROR: view name does not exist
	      This  message occurs if the specified view does not exist in the
	      database.

DESCRIPTION
       DROP VIEW drops an existing view from the database.   To	 execute  this
       command you must be the owner of the view.

   NOTES
       Refer to CREATE VIEW for information on how to create views.

USAGE
       This command will remove the view called kinds:

       DROP VIEW kinds;

COMPATIBILITY
   SQL92
       SQL92 specifies some additional capabilities for DROP VIEW:

       DROP VIEW view { RESTRICT | CASCADE }

   INPUTS
       RESTRICT
	      Ensures  that  only  a view with no dependent views or integrity
	      constraints can be destroyed.

       CASCADE
	      Any referencing views and integrity constraints will be  dropped
	      as well.

   NOTES
       At  present,  to remove a referenced view from a Postgres database, you
       must drop it explicitly.

SQL - Language Statements	 29 March 2001			   DROP VIEW()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server BSDOS

List of man pages available for BSDOS

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net