view

Create view sampleView as select city.countryCOde As abbr, country.Name As fullName from city; 

 

Select * from sampleView; 

 

 

Create view sampleView as [select city.countryCOde As abbr, country.Name As fullName from city;] 

괄호로 만든다 테이블을 만들어서 뷰를 만든다.