What will happen in such case to the table

[cmrhema]

Hi,
At present I dont have Sql Server, so cant test it out.
Kindly clarify some doubts.

I have a table named A which has fields emp, empno, empaddress. Here empno is a primary key.

I am going to create a view V, which will fetch only emp and empno.

My question is can i insert datas into V, and will it affect the table A.

Kindly excuse me, as i dont have sql server I could not try out this simple question.

Thanks in Advance

Regards
cmrhema

[Jibran]

No, it'll not as Views and Tables have no association with each other.

[ck9663]

Depends on how you want to handle the UPDATE process. There is a way to UPDATE a view if you have to. By definition, you can not update a view, as it is.


-- CK