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 the maximum number of index per table?
How to execute stored procedure and set temp table in sql server?
Which tcp/ip port does the sql server run on? How can it be changed?
What do you mean by 'normalization'?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is Federation Root Database?
What is difference between getdate and sysdatetime in sql server 2008?
Detail about the hardware which is supported by SQL server?
What is inner join in sql server joins?
Give an example of why you would want to denormalize a database
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
How to delete duplicate rows?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Can a table be moved to different filegroup?
What is the default Port No on which SQL Server listens?
