sql view

 In this post includs the sql view 

1) view is virtual table 

2) up to date real time data

Create view:-

create view view_name as 

select * from Table_name

Update view:- 

create or replac view view_name as 

select * from Table_name

Drop view:- 

drop view view_name

show view: - 

select * from view_name