[DB 개념] VIEW 테이블

VIEW 테이블

 

• 실질적으로 존재하는 테이블이 아니라 정의만 가지고 있음
  가상 READ ONLY 테이블, 사용에 있어서 SELECT 만 가능!
• create view [뷰테이블명] as
  [쿼리 작성]
  ;
• drop view [뷰테이블명];

 

 

create view v_members as
select m.member_type, m.user_id, m.password, m.name
, md.mobile_no, md.marketing_yn, md.register_date
from members as m
join members_detail as md
on m.member_type = md.member_type and m.user_id = md.user_id
where marketing_yn = true;