Updating views in sql server
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community During College it was banged into our heads to not update tables through views, and again when I got into the workplace we where told do not update the database through views.
Where there/Are there significant performance implications to doing this?
A view is nothing more than a SQL statement that is stored in the database with an associated name.
A view is actually a composition of a table in the form of a predefined SQL query.
Or is this more a case of senior developers/DBAs' telling junior personnel not to do this because they can unwittingly wreak havoc with an incorrect join.
EDIT I'm using MSSQL 2000-2008 (Depending on the particulars of the client) triggers "SQL Server must be able to unambiguously trace modifications from the view definition to one base table.".; microsoft.support = microsoft.support
However, we should be very careful while customizing a table because sometimes other objects are dependable on a table and can give consistency issues as well.