Why do you create a View in a database?

by

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 (or tables), 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.

More Related Contents:

  1. Generate a resultset of incrementing dates in TSQL
  2. T-SQL Cast versus Convert
  3. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  4. What is the difference between using a cross join and putting a comma between the two tables?
  5. What does =* mean?
  6. Correct use of transactions in SQL Server
  7. Need to list all triggers in SQL Server database with table name and table’s schema
  8. Know relationships between all the tables of database in SQL Server
  9. SQL Server search using like while ignoring blank spaces
  10. Subquery using Exists 1 or Exists *
  11. Truncate (not round) decimal places in SQL Server
  12. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  13. Update records in table from CTE
  14. Dynamic Pivot Columns in SQL Server
  15. Is it possible to select sql server data using column ordinal position
  16. Selecting N rows in SQL Server
  17. How can I INSERT data into two tables simultaneously in SQL Server?
  18. SQL “select where not in subquery” returns no results
  19. How can a LEFT OUTER JOIN return more records than exist in the left table?
  20. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  21. Calculate the number of records for each date between 2 dates
  22. T-SQL: How to use parameters in dynamic SQL?
  23. How to compare datetime with only date in SQL Server
  24. Merge overlapping date intervals
  25. SQL server select distinct rows using most recent value only
  26. Split words with a capital letter in sql
  27. SQL poor stored procedure execution plan performance – parameter sniffing
  28. scope_identity vs ident_current
  29. Cumulative Total in MS Sql server [duplicate]
  30. What does ON [PRIMARY] mean?

Leave a Comment