SQL VIEW [message #22828] |
Thu, 31 October 2002 09:21 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
A view is a snapshot of a table. My questions are::
1. Can we modify the data of the view?
2. If you create a view and later if you change the table, what will be the impact on the view??
|
|
|
Re: SQL VIEW [message #22829 is a reply to message #22828] |
Thu, 31 October 2002 09:24 |
satish
Messages: 112 Registered: September 2000
|
Senior Member |
|
|
View is just like a query its virtual, so it gives you the latest information even if there is a change in table data.
Regards,
Satish.
|
|
|