Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

RedHat 9 (Linux i386) - man page for drop_view (redhat section 7)

DROP VIEW(7)				   SQL Commands 			     DROP VIEW(7)

NAME
       DROP VIEW - remove a view

SYNOPSIS
       DROP VIEW name [, ...] [ CASCADE | RESTRICT ]

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

       CASCADE
	      Automatically drop objects that depend on the view (such as other views).

       RESTRICT
	      Refuse to drop the view if there are any dependent objects.  This is the default.

   OUTPUTS
       DROP VIEW
	      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 [create_view(7)] for information on how to create views.

USAGE
       This command will remove the view called kinds:

       DROP VIEW kinds;

COMPATIBILITY
   SQL92
SQL - Language Statements		    2002-11-22				     DROP VIEW(7)


All times are GMT -4. The time now is 04:55 PM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password