VIEW (view) in SQL is a virtual table, through which we can see a piece of data from one or more tables. VIEW does not contain any data, and is used to restrict database access or to hide complex data. To learn more about VIEW in SQL, read the following article of

In the previous articles, introduced you to SQL commands, including CREATE, DELETE, INSERT, … The following article will introduce you more about VIEW in SQL.

VIEW (views) in SQL are stored as SELECT statements in a database. DML operations in VIEW such as INSERT, UPDATE, DELETE affect the data in the original table.

Syntax creating VIEW in SQL

The syntax for creating VIEW in SQL is:

CREATE VIEW view_name


SELECT column_list

FROM table_name [WHERE condition];


view_name is the name of VIEW.

– The SELECT statement is used to identify the columns and rows you want to display on VIEW.

Example VIEW in SQL

To create VIEW in the product table, the SQL query is written as follows:

CREATE VIEW view_product


SELECT product_id, product_name

FROM product;
Above is the information about VIEW in SQL. In addition to the basic commands that introduced earlier, to learn more about the commands that grant and revoke privileges, permissions in SQL, or other commands such as Index in SQL To delete data, readers can find out the latest SQL articles on


Add a Comment

Your email address will not be published. Required fields are marked *