How To Drop an Existing View?
Page 1 of 1
How To Drop an Existing View?
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.
VIEW statement as shown in the following script:
DROP VIEW employee_department;
View dropped.
Similar topics
» How To Drop an Existing Table?
» How To View All Columns in an Existing Table?
» How To Add a New Column to an Existing Table?
» How To Drop an Index?
» How To Drop a Tablespace?
» How To View All Columns in an Existing Table?
» How To Add a New Column to an Existing Table?
» How To Drop an Index?
» How To Drop a Tablespace?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Sun Jan 31, 2010 12:35 am by Micheal
» Accessing tables of other users in SQL
Sun Jan 31, 2010 12:34 am by Micheal
» Grouping commands in SQL
Sun Jan 31, 2010 12:32 am by Micheal
» Operations on Result Sets in SQL
Sun Jan 31, 2010 12:31 am by Micheal
» Subqueries in SQL
Sun Jan 31, 2010 12:30 am by Micheal
» Joining Relations in SQL
Sun Jan 31, 2010 12:28 am by Micheal
» Delete comand in SQL
Sun Jan 31, 2010 12:27 am by Micheal
» Update command in SQL
Sun Jan 31, 2010 12:26 am by Micheal
» Insert command in SQL
Sun Jan 31, 2010 12:23 am by Micheal