How to Create a View in Sql Server

A view does not exists physically but still it acts like a table and it returns a record set as a table does. A important advantage of having a view is we can hide sensitive information from tables being selected.

CREATE VIEW [dbo].[TestView]
AS
SELECT * FROM tblABS

Execute the view.

select * from TestView