Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Yes No. Any additional feedback? Skip Submit. Submit and view feedback for This product This page. View all page feedback.
Create Indexed Views. Modify Data Through a View. Posted Dec pm Sergey Alexandrovich Kryukov. Then y u r in a member of this code project. Sergey Alexandrovich Kryukov Dec pm. First of all, have a little respect to members, stop using your 'y', 'u', 'r', etc. And then, if you saying has some meaning, feel free to explain it to us.
Good luck, —SA. I think we should also respect those who ask the question by giving them the proper answer instead of blaming them for asking 'stupid' question. Some people might easily feel disrespected. Sergey Alexandrovich Kryukov Oct am. Nobody is blaming anyone for a stupid question; this is your own idea and your word.
You are perfectly right, but I think this answer is "proper enough". OP will read it, referenced article, understand it, and also get an idea hot to find the information next time. Is it any bad? Member Mar pm. Girish Kalamati 6-Jan am.
A table contains data, a view is just a SELECT statement which has been saved in the database more or less, depending on your database. The advantage of a view is that it can join data from several tables thus creating a new view of it. Say you have a database with salaries and you need to do some complex statistical queries on it. In case the other explanations are too technical for you: - Tables are the actual database entities that hold your rows. Tables as you know store the actual data.
Views will require and use actual columns from the actual tables. The rows are filtered in your SQL statement when creating the view. They are typically used to viewing specific data sets for easy access or decision making. For example, I have a view that is constructed based on my Customer and Order table.
This view only has the columns that I need to fill out invoices. Having this view will save on typing SQL statements to join the two tables and the rest of the logic and output specific columns and rows while I can just use a select all statement to get all I need all of course must be defined in view when creating it; other select statements can further filter a view. There are limitations and restrictions to updating and deleting from views.
That I will leave you to read up on. Posted Dec pm Krunal Rohit. Thumbs up. View : 1. Data security : Views can include only certain columns in the table so that only the non-sensitive columns are included and exposed to the end user.
In addition, some databases allow views to have different security settings, thus hiding sensitive data from prying eyes. Speed to deployment : Sometimes you want a table that is built on top of the existing data set, but in order to make this happen, you'll need to work with your engineering team to go through the process of defining, populating, and maintaining a new table, and this can be time-consuming.
Instead of going that way, creating a view may be a much faster way to go. Since a view doesn't hold actual data and doesn't need to be refreshed on a regular cadence, it can be deployed much faster, and sometimes you might even be able to create the view yourself. Like many things, there are also tradeoffs that come with using views. Below are a few disadvantages of using views: 1. Query performance : While a query into a view is usually simple to write and easy to understand, the actual query that the database has to execute will be as complex as the view definition because the query still needs to occur at the table level.
0コメント