By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,660 Members | 1,593 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,660 IT Pros & Developers. It's quick & easy.

What will happen in such case to the table

P: 375
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

Mar 12 '09 #1
Share this Question
Share on Google+
2 Replies

P: 30
No, it'll not as Views and Tables have no association with each other.
Mar 12 '09 #2

Expert 2.5K+
P: 2,878
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
Mar 12 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.