What is the command used to define view in sql?

SQL

Could someone tell me which command should we use to define the view in SQL?


If you want to unleash your potential in this competitive field, please visit the SQL course page for more information, where you can find the SQL tutorials and SQL frequently asked interview questions and answers as well.

1
Answers

Replies

A view is referred to as a virtual table that is based on the result set of the SQL statements. A view compirises of the rows and columns that is same as the real table. You are allowed to add the SQL functions like WHERE  and JOIN statements. The command that is used to define the view in SQL is the create view command. Below is the syntax of CREATE VIEW.



CREATE VIEW view_name ABC


SELECT column1, column2, ...


FROM table_name


WHERE condition;

 
 

This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.
WhatsApp
To Top