Can we delete data through view ?

Question

Can we delete data through view ?

dsachu

SSCrazy

Points: 2242
More actions
February 27, 2012 at 4:21 am

#252194

Hi,
Can we delete/insert/update data through view. This view are using multiple tables.
Regards,
Sachin.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

As long as you update data from a single table, yes.

As far as deletes is concerned, I don't think you can force deletion from a specific table and I guess you will have to code a trigger (INSTEAD OF kind) for that.

-- Gianluca Sartori

dsachu SSCrazy Points: 2242 More actions · Answer 2

dsachu

SSCrazy

Points: 2242

February 27, 2012 at 4:58 am

#1451985

thanks a lot...:-)

sumitagarwal781 Default port Points: 1493 More actions · Answer 3

To delete data through a view example.

http://technet.microsoft.com/en-us/library/ms189835.aspx

java

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

sumitagarwal781 (2/27/2012)
To delete data through a view example.
http://technet.microsoft.com/en-us/library/ms189835.aspx

I'm not saying it can't be done, but some restrictions apply.

BOL says:

The view referenced by table_or_view_name must be updatable and reference exactly one base table in the FROM clause of the view. For more information about updatable views, see CREATE VIEW (Transact-SQL).

See my point? Multiple joined tables means you have to code a trigger.

-- Gianluca Sartori

durai nagarajan SSCoach Points: 15778 More actions · Answer 5

i completely agree with Gianluca Sartori

we have to include a trigger for proper action on all tables.

Regards
Durai Nagarajan