A view is a virtual table based on the result-set of an sql statement.

Create

CREATE VIEW [DBO].V_PESSOA WITH SCHEMABINDING
AS

SELECT    nome
         ,endereco
         ,email
FROM  [DBO].pessoa
GO


Using

select *
from dbo.v_pessoa

see u…