What are views good for?

by

In a way, a view is like an interface. You can change the underlying table structure all you want, but the view gives a way for the code to not have to change.

Views are a nice way of providing something simple to report writers. If your business users want to access the data from something like Crystal Reports, you can give them some views in their account that simplify the data — maybe even denormalize it for them.

More Related Contents:

  1. Why is using ‘*’ to build a view bad?
  2. What is the difference between Views and Materialized Views in Oracle?
  3. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  4. adding primary key to sql view
  5. Difference between View and table in sql
  6. What is the difference between a stored procedure and a view?
  7. Row Rank in a MySQL View
  8. Why isn’t row level security enabled for Postgres views?
  9. How to create a Calendar table for 100 years in Sql [closed]
  10. Oracle Differences between NVL and Coalesce
  11. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  12. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  13. How can I query a value in SQL Server XML column
  14. SQL Server indexes – ascending or descending, what difference does it make?
  15. MySQL: View with Subquery in the FROM Clause Limitation
  16. Write a number with two decimal places SQL Server
  17. Group DateTime into 5,15,30 and 60 minute intervals
  18. How to see all the tables in an HSQLDB database?
  19. Aggregating (x,y) coordinate point clouds in PostgreSQL
  20. Merge overlapping date intervals
  21. How does a Recursive CTE run, line by line?
  22. SQL poor stored procedure execution plan performance – parameter sniffing
  23. Improving performance of cluster index GUID primary key
  24. Mysql strip time component from datetime
  25. How to find out what is locking my tables?
  26. Linq to SQL: How do I stop the auto generated object name from being renamed?
  27. Using django how can I combine two queries from separate models into one query?
  28. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  29. Previous Monday & previous Sunday’s date based on today’s date
  30. SQL add filter only if a variable is not null

Leave a Comment