Oracle - Drop an Existing View in Oracle

Drop an Existing View in Oracle

Q

How To Drop an Existing View in Oracle?

✍: FYIcenter.com

A

If you have an existing view, and you don't want it anymore, you can delete it by using the DROP VIEW statement as shown in the following script:

DROP VIEW employee_department;
View dropped.

⇒Understanding SQL DDL Statements for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 165👍, 0💬

Popular Posts:

About dba.FYIcenter....

What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...

Creating Multi-State...

How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi...

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...