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

Popular Posts:

NULLIF() - Replacing...

How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...

Using User Defined F...

Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...

CONVERT() - Converti...

How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...