ALTER VIEW


baham ko'ring

ALTER VIEW

SQL Serverda ko‘rinish ALTER VIEW buyrug‘i bilan yangilanishi mumkin.

Quyidagi SQL "City" ustunini "Brazil Customers" ko‘rinishiga qo‘shadi:

Misol

ALTER VIEW [Brazil Customers] AS
SELECT CustomerName, ContactName, City
FROM Customers
WHERE Country = "Brazil";

Ko‘rinishdan (view) so‘rov qilish

Yuqoridagi ko‘rinishni quyidagicha so‘rashimiz mumkin:

Misol

SELECT * FROM [Brazil Customers];

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!