Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
What is View in SQL and what is the use of it?
Home
Sql
What is View in SQL and what is the use of it?
0
votes
asked
Nov 26, 2020
in
Sql
by
SakshiSharma
What is View in SQL and what is the use of it?
#sql-view
use-of-view-sql
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Nov 26, 2020
by
rajeshsharma
A View can be defined as a virtual table that contains rows and columns with fields from one or more tables.
Syntax:
CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Related questions
0
votes
Q: What are the steps to update the view in SQL
asked
Nov 26, 2020
in
Sql
by
SakshiSharma
#sql-view
#view-sql-update
0
votes
Q: Can a View based on another View in SQL/
asked
Jul 13, 2020
in
Sql
by
Robindeniel
#sql-another-view
#sql-view
0
votes
Q: What is a SQL View?
asked
Jul 13, 2020
in
Sql
by
Robindeniel
#sql-view
#view-sql
0
votes
Q: What is View in SQL?
asked
Jul 6, 2020
in
Sql
by
Robindeniel
#view-sql
#sql-view
0
votes
Q: What is a view in SQL?
asked
Nov 7, 2021
in
Sql
by
rajeshsharma
view-sql
sql-view
0
votes
Q: Does View contain Data in SQL??
asked
Jul 13, 2020
in
Sql
by
Robindeniel
#sql-view-data
0
votes
Q: How we can update the view in SQL?
asked
Jul 6, 2020
in
Sql
by
Robindeniel
#sql-view-update
#view-update-sql
0
votes
Q: What do you mean by Stored Procedures in SQL? How do we use it?
asked
Jul 8, 2020
in
Sql
by
Robindeniel
#sql-stored-procedures
#stored-procedures-sql
+2
votes
Q: Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?
asked
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
0
votes
Q: Is it possible for a table to have more than one foreign key in SQL?
asked
Jul 10, 2020
in
Sql
by
Robindeniel
#foreign-key
#sql-foreign-key
...