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 method you can use to reduce the overhead of Reporting Services data sources?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What are the properties of primary key?
How to populate a table in sql server?
Do you know what is similarity and difference between truncate and delete in sql?
What is tablix?
How to change parameter value inside the report?
How to convert a unicode strings to non-unicode strings?
How many databases can we create in a single server?
What is temporary table in sql server? Why we use temp table?
What is the difference between dbcc indexdefrag and dbcc reindex?
What are the diifferences between the ms sql server vs mysql?
Can we call future method from queueable?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Can sql server be linked with other servers like oracle?