Sql views
0 likes160 views
Views are virtual tables that allow selective portions of data from one or more tables to be seen without containing data themselves. They are used to restrict access or hide complexity by storing a SELECT statement that defines which columns and rows to display from the underlying table. A view is created using the CREATE VIEW statement followed by a SELECT query to define the columns from the table and can be used to perform DML operations that affect the original table data.
Sql views
- 1. 8/10/13 SQL Views beginner-sql-tutorial.com/sql-views.htm 1/1 SQL Views A VIEW is a virtual table, through which a selective portion of the data from one or more tables can be seen. Views do not contain data of their own. They are used to restrict access to the database or to hide data complexity. A view is stored as a SELECT statement in the database. DML operations on a view like INSERT, UPDATE, DELETE affects the data in the original table upon which the view is based. The Syntax to create a sql view is CREATE VIEW view_name AS SELECT column_list FROM table_name [WHERE condition]; view_name is the name of the VIEW. The SELECT statement is used to define the columns and rows that you want to display in the view. For Example: to create a view on the product table the sql query would be like CREATE VIEW view_product AS SELECT product_id, product_name FROM product;