Updatable View - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Updatable View

Author

Topic

mahesh_bote
Constraint Violating Yak Guru

298 Posts

Posted - 2006-07-24 : 05:12:23

Can anybody tell me, in which condition, Views are Insertable, updatable, and which condition they are not.

Thanks in advance,

MH 09 AM 8694

BMahesh

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-07-24 : 05:18:40

Check that on Book online under Create View Section, they have good explaination.

Chirag

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-07-24 : 05:22:11

quote:
Originally posted by mahesh_bote

Can anybody tell me, in which condition, Views are Insertable, updatable, and which condition they are not.

Thanks in advance,

MH 09 AM 8694

BMahesh

I found the following conditions for a view to be updatable:
1. the keyword DISTINCT is used in the view definition
2. the select list contains components other than column specifications, or contains more than one specification of the same column
3.the FROM clause specifies more than one table reference or refers to a non-updatable view
4.the GROUP BY clause is used in the view definition
5.the HAVING clause is used in the view definition

anybody has anything more to add ?