View

 1. Membuat View

CREATE VIEW Nama_View
As
Ekspresi_SELECT

CREATE VIEW vEmployee

AS

SELECT NIK, Name, Addreess, City, Salary

FROM t_Employees

SELECT * FROM vEmployee

2. Mengubah View

ALTER VIEW Nama_View

As

Ekspresi_SELECT

ALTER VIEW vEmployee

AS

SELECT NIK, Name, Addreess AS Alamat, City as Kota, Salary as Gaji

FROM t_Employees