solutions related to sql problems
|
|
|
Question / Problem
|
what is difference between DROP TABLE & DROP VIEW in SQL?
|
Solution
|
DROP TABLE commands drops a table whereas DROP VIEW drops a view that is virtual form of physical database.
DROP TABLE will work on empty table only, whereas in the DROP VIEW deletion of rows is not necessary.
|
Applies to |
|
My Sql
|
Rank It |
|
