VIEW
CREATE VIEW
SQLda ko‘rinish SQL operatorining natijalar to‘plamiga asoslangan virtual jadvaldir.
CREATE VIEW buyrug‘i ko‘rinish (view) yaratadi.
Quyidagi SQL Braziliyadagi barcha mijozlarni tanlaydigan ko‘rinishni yaratadi:
Misol
CREATE VIEW [Brazil
Customers] AS
SELECT
CustomerName, ContactName
FROM Customers
WHERE
Country = "Brazil";
Ko‘rinishdan (view) so‘rov qilish
Yuqoridagi ko‘rinishni quyidagicha so‘rashimiz mumkin:
Misol
SELECT * FROM [Brazil Customers];
CREATE OR REPLACE VIEW
CREATE OR REPLACE VIEW buyrug‘i ko‘rinishni yangilaydi.
Quyidagi SQL "City" ustunini "Brazil Customers" ko‘rinishiga qo‘shadi:
Misol
CREATE OR REPLACE VIEW [Brazil Customers] AS
SELECT CustomerName, ContactName, City
FROM Customers
WHERE Country = "Brazil";
DROP VIEW
DROP VIEW buyrug‘i ko‘rinishni o‘chiradi.
Quyidagi SQL "Brazil Customers" ko‘rinishini o‘chiradi:
Misol
DROP VIEW [Brazil Customers];
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!