Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rhys
A view is a "virtual" (isn't physically stored) table. It hides complex details (you can join multiple tables together), provides security/privacy (users can set which columns are available for different people) and it allows read-only access.
The view data dictionary will be updated along side the master data dictionary. For example, if I updated a client's name in the master table, the view would also be amended.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is create statement?
What is the difference between a primary key and a unique key? Are they the same?
How to create a large table with random data for index testing in ms sql server?
Introduction of rollup clause using sum and group by clause?
Please illustrate physical database architecture? : SQL Server Architecture
what is spatial nonclustered index
What is transaction server explicit transaction?
How to store and query spatial data?
What are the advantages of the mirroring?
What is the difference between grant and with grant while giving permissions to the user?
What is a primary index?
Determine when to use stored procedure to complete sql server tasks?
What are the 10 characteristics of data quality?
What is candidate key with example?
Explain the ways to controlling cursor behavior?
