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.

Is ssrs support other database except ms sql server?

127

---

Can you always create a cache of a report?

156

---

What is difference between primary key and foreign key?

833

---

What xml support does the sql server extend?

954

---

How to link tables in sql server?

889

---

How to find out the list schema name and table name for the database?

893

---

How to create a simple stored procedure in ms sql server?

973

---

Difference between LEN() and DATALENGTH() in sql server ?

1056

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

894

---

How to recompile stored procedure at run time?

1005

---

What happens when transaction log is full?

868

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4295

---

What is Replication?

988

---

Can we hide the definition of a stored procedure from a use?

1131

---

How to define and use table alias names in ms sql server?

1041

---