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

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

ck9663
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.