MS SQL Server Concepts and Programming Question:
Download Questions PDF

What Are Views in MS SQL Server?

Answer:

A view is a database object that represents the data in one or more tables in the same structure as a separate table. Here are some basic rules about views:

* Tables store real data.
* Views do not store real data.
* Views must have underlying tables to provide data.
* Each view is based on a single SELECT statement to control what data to collect from tables, and how data should be represented.
* View's columns can be mapped directly to columns in underlying tables.
* View's columns can be created expressions based multiple columns in underlying tables.
* Views can be used in same way as tables in queries.


Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
How To Recreate an Existing Index in MS SQL Server?How To Create a View on an Existing Table in MS SQL Server?