Collections:
Drop an Existing View in Oracle
How To Drop an Existing View in Oracle?
✍: FYIcenter.com
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.
2020-02-07, 680👍, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...