Answer Posted / waseem
a view is a virtual table based on the result-set of an SQL
statement.
The fields in a view are fields from one or more real tables
in the database.
You can add SQL functions, WHERE, and JOIN statements to a
view and present the data as if the data were coming from
one single table.
A view always shows up-to-date data! The database engine
recreates the data, using the view's SQL statement, every
time a user queries a view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is postgresql server?
what is the difference between delete table and truncate table commands? : Sql server database administration
What does it mean to normalize a database and why would you do it?
What are page splits?
How to use union to merge outputs from two queries together in ms sql server?
Can you pass expressions to function parameters?
how to overcome kernel isssues
What is the difference between sdf and mdf?
How to find the source of a table in sql server?
What is federation member?
What do mean by xml datatype?
what is a join and explain different types of joins? : Sql server database administration
Explain view in sql server?
What are types of subqueries?
Can we call future method from queueable?