Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Views question ?
- Thread starter hanglam
- Start date
MS SQL Server and Sybase are quite similar on the capabilitis to updete views, there are some restrictions for a view to be updatable:
- Do not include computed columns
- Do not inlcude aggregate values (group by, compute)
- Do not reference more than one table (update and insert sometimes are possible)
- View with check option only allow to manage rows visible within the view
- Insert not possible if not null columns are not included in the view
- Update not possible if Identity columns are included
- Do not include computed columns
- Do not inlcude aggregate values (group by, compute)
- Do not reference more than one table (update and insert sometimes are possible)
- View with check option only allow to manage rows visible within the view
- Insert not possible if not null columns are not included in the view
- Update not possible if Identity columns are included
- Status
Similar threads
