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 a partitioned view?
How many replicas are maintained for each SQL Azure database?
Which language is supported by sql server?
How to reaname table name without using sp_Rename in sql server..?
How to create an inline table-valued function?
What are user defined functions in ms sql server?
What are number line correlation administrators will use while working with a subquery?
List the different index configurations possible for a table?
Give an example of why you would want to denormalize a database
What is a data collection table?
What is field with example?
What do you mean by SQL injection attack?
How to list all columns in a table using odbc_columns()?
Do you know what is similarity and difference between truncate and delete in sql?
Why use stored procedures in sql server?
