View

• View是一個以查詢來建構的虛擬table

• Create view view_name (a,b) as Query

  • create view man (name,tel,address) as select name,tel,address from main where gender='男';

• View是用來簡化查詢

• 通常不能對View下update、insert與 delete指令