A database view is a virtual table which is defined as a SQL select query with JOIN statement. Same as database table it consists of rows and columns.
When any data of a tables changes, the corresponding view reflects that changes as well.
Advantages:
Disadvantages:
Simple view example:
CREATE VIEW userOrder AS SELECT userID, orderID SUM (qty * price) total FROM orders GROUP by orderID ORDER BY total DESC
You can also use JOIN and sub-query to the view.
Once a view created in a database, you can remove it by using the DROP VIEW statement:
DROP VIEW [IF EXISTS] userOrder
After a view is defined, you can modify it by using the ALTER VIEW statement:
ALTER VIEW userOrder AS SELECT userID, orderID, discount_amount SUM (qty * price) total FROM orders GROUP by orderID ORDER BY total DESC
To create a updateable views you need to consider following things:
UPDATE userOrder SET total = 2250 WHERE userID = 5 AND orderID = 135
Glass at height is easy to overlook, in both senses. It is out of reach,…
Almost every rental business starts the same way. A handful of items, a notebook or…
When it comes to designing the office interior you need a highly professional designer. Your…
Emergencies can happen anywhere, whether at home, in the workplace, at school, or during outdoor…
A dental practice’s website is essential, but it is only one place where prospective patients…
Golf is often described as a game of patience, practice, and precision. That is true,…