Answer Posted / dr.job418

A view provides several benefits.

1. Views can hide complexity

If you have a query that requires joining several tables, or has complex logic or calculations, you can code all that logic into a view, then select from the view just like you would a table.

2. Views can be used as a security mechanism

A view can select certain columns and/or rows from a table, and permissions set on the view instead of the underlying tables. This allows surfacing only the data that a user needs to see.

3. Views can simplify supporting legacy code

If you need to refactor a table that would break a lot of code, you can replace the table with a view of the same name. The view provides the exact same schema as the original table, while the actual schema has changed. This keeps the legacy code that references the table from breaking, allowing you to change the legacy code at your leisure.

These are just some of the many examples of how views can be useful.

What is the beast way to write CTE in SQL Server ?

1093

---

What is meant by referential integrity?

1046

---

what is difference between NULL and ISNULL in SQL Server 2008?

1058

---

How the authentication mode can be changed?

1175

---

Explain trigger classes i.e. Instead of and after trigger?

917

---

what is bit datatype? : Sql server database administration

960

---

What is an index in sql?

1066

---

How can we migrate from SQL server to SQL Azure?

113

---

What are distributed partitioned views?

1134

---

What are the recovery models for a database?

1145

---

How to replace the Query Result 'Null Value' with a text ?

1093

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1346

---

How do I view a trc file?

977

---

What do you mean by data manipulation language?

1063

---

Can we write a distributed query and get some data which is located on other server and oracle database?

1275

---