Breaking

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