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
Create and insert into temp table in sql server?
How do I view a script in sql server?
Explain transaction server explicit transaction?
What are the authentication modes in sql server? How can it be changed?
List some major differences between triggers and stored procedures?
How to modify existing triggers using "alter trigger"?
Explain the steps needed to create a scheduled job?
List out the difference between union and union all in sql server?
Explain a join?
What is onf in normalization form?
Explain syntax for dropping triggers?
What is 3nf normalization form?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is the use of custom fields in report?
Explain foreign key in sql server?
