Alex Rivera | Logout

If I update a view, will my original tables get updated

Asked 2010-04-15T19:41:39.873
47

Hypothetically I have two tables Employee and Locations. Additionaly I have a view viewEmpLocation which is made by joining Employee and Locations.

If I update the view, will the data in the original table get updated?

sql sql-server sql-server-2005 t-sql view
Edit
Report

1 Answer

5

You could use a trigger on the view to do an insert/update/delete to the actual tables.

http://www.devarticles.com/c/a/SQL-Server/Using-Triggers-In-MS-SQL-Server/1/

answered 2010-04-15T20:58:50.920

Your Answer