Solved

SQL Deleting Views Trouble

Posted on 2012-04-06
4
541 Views
Last Modified: 2012-07-13
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.
Please help.
0
Comment
Question by:J3Brother
4 Comments
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 125 total points
ID: 37817614
Hi. Please note the last portion of the error, "you do not have permission." Is there a possibility that the account you are using does not have the DROP VIEW permission? What schema did you create the views in originally? i.e., double check that you are in the correct database and referencing the views with the proper qualified name.
0
 
LVL 15

Assisted Solution

by:deepakChauhan
deepakChauhan earned 125 total points
ID: 37817741
please check view name in sys.view  system view  or you can see all these in view folder in management studio. if these all view are able to see it then check drop permission and database  also.
0
 
LVL 3

Assisted Solution

by:MrHswede
MrHswede earned 125 total points
ID: 37817775
it could also be that you are trying to execute a delete for the views on the incorrect database.

Try to use this syntax:

Use MyDb (replace it with the database where the views reside)
GO

Drop view MyView1
Drop view MyView2
etc

/Martin
0
 
LVL 7

Accepted Solution

by:
Anoo S Pillai earned 125 total points
ID: 37818090
Connect to SQL server through SQL Server Management Studio, create a DROP view script from there. ( Please see the picture ) . Execute the drop script on the database. ( To confirm whether this is a real permission issue )
DropViewIf drop command fails; this could be a  permission issue, you should grant required permissions ( say for example GRANT ALTER ON view to the user).
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql help 8 55
Need help on t-sql 2012 10 53
T-SQL: Creating Records Where There Are None2 - The Sequel 6 26
insert wont work in SQL 14 18
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now