Is there any advantage of creating views for tables in SQL, compared to directly query the table?
Asked
Active
Viewed 160 times
1 Answers
0
Views help you hide sensitive columns that you don't want to show certain type of users by limiting the degree of exposure to the underlying tables. You can also wrap joined multiple tables into a single view (virtual table) that can easily be queried as a single table.
Israel H.
- 54
- 4