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, 182👍, 0💬

Popular Posts:

Downloading and Inst...

How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...

EXECUTE - Executing ...

How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...

Define External Tabl...

How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...

WHILE ... Loops in S...

How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...

What Is Microsoft SQ...

What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...