| How to delete View in SQL and how to update that
Below are the some useful fact about the View. SQL view is table which is not exist physically it is only virtual table.Below is the syntax to create view
CREATE VIEW Test_View AS Select Col1,Col2,Col3,Col4 from table_name where conditions
Now if we want to delete SQL view then command is written below to delete the views
DROP VIEW Test_View
But one fact is that if we want to change some values or tables column in Views then we need to DROP it first then we need to re-create this. So for update we need to DROP view then recreate it. | | |