Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Modifying data through views [Table of Contents] Using views as security mechanisms

Transact-SQL User's Guide

[-] Chapter 9 Views: Limiting Access to Data
[-] Dropping views

Dropping views

To delete a view from the database, use drop view: 

drop view [owner.]view_name [, [owner.]view_name]...

As indicated, you can drop more than one view at a time. Only its owner (or the database owner) can drop a view.

When you issue drop view, information about the view is deleted from sysprocedures, sysobjects, syscolumns, syscomments, sysprotects, and sysdepends. All privileges on that view are also deleted.

If a view depends on a table or on another view that has been dropped, Adaptive Server returns an error message if anyone tries to use the view. If a new table or view is created to replace the one that has been dropped, and if it has the same name as the dropped table or view, the view again becomes usable, as long as the columns referenced in the view definition exist.

Modifying data through views [Table of Contents] Using views as security mechanisms