Home > DeveloperSection > Interviews > What is View in Database?

Posted on    October-20-2010 12:00 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  951  View(s)
Rate this:

Rajesh Goswami

Total Post:85

Posted on    November-09-2010 1:00 AM

A view can be thought of as either a virtual table or a stored query. Unless a view is indexed, its data is not stored in the database as a distinct object.

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Don't want to miss updates? Please click the below button!

Follow MindStick