• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

How do I delete records from a view in SQL Server 2000?

I tried "DELETE FROM view WHERE field=N'value'" but it gives me this:

view is not updatable because the modification affects multiple base tables.

I don't know where the view takes the records from.
2 Solutions
you can put an INSTEAD OF trigger on the view.
Anthony PerkinsCommented:
Why don't you post the View and we may be able to help you more.

What the error message is suggesting to you is that DELETE can only operate on one table at a time.
datalink01Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now