SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How To Drop an Existing View?

Go down

How To Drop an Existing View? Empty How To Drop an Existing View?

Post by Micheal Sat Jan 16, 2010 9:31 pm

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.

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum