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

Popular Posts:

Verifying SQL Server...

How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...

SQL Server Database ...

Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...

Running Queries with...

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...

What Causes Index Fr...

What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...

Transaction Manageme...

Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...