Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

DROP VIEW

Name

DROP VIEW -- Removes an existing view from a database.

Synopsis

DROP VIEW name [, ...]

Parameters

name

The name of the view you wish to remove.

Results

DROP

The message returned when a view is successfully dropped.

ERROR: view "name" does not exist

The error returned if the view name does not exist in the current database.

Description

Use the DROP VIEW command to remove a view from a database. As with most objects, you must be the owner a view to remove it.

Example

The following example removes the h_ publishers view from the booktown database:

booktown=# DROP VIEW h_ publishers;
DROP

 
 
  Published courtesy of O'Reilly Design by Interspire