How to create view in sql server?

CREATE VIEW view_name 

AS

SELECT column1, column2

FROM table_name

WHERE condition;

After creation, view can be called by:

SELECT * FROM view_name;

Hi Pawan

Create view Vw_Clienttable // Create view viewname
as

select * from Clienttable // query for required result

create view viewname

http://www.c-sharpcorner.com/UploadFile/rohatash/creating-a-view-programmatically-in-sql-server-2012/

Create view myview as select * from table name.