I am using SQL Server 2008 R2 Studio Manager and using the Northwind Database.
I created 4 views, emp_vu1, prod_cat_vu, m_emp_vu, and mexico_cust_vu and I am having trouble deleting these views.
This is the code:
DROP VIEW emp_vu1
DROP VIEW prod_cat_vu
DROP VIEW m_emp_vu
DROP VIEW mexico_cust_vu
I get an error that says:
"Cannot Drop the View because it does not exist or you do not have permission"
The views are their since I created them but just cannot drop them.