Views are virtual tables based on SELECT queries. Simplify complex queries and control data access.

Create View

CREATE VIEW active_customers AS

SELECT id, name, email

FROM customers

WHERE status = 'active';

Use View

SELECT * FROM active_customers;

View with JOIN

CREATE VIEW order_details AS

SELECT o.id, c.name, o.total, o.order_date

FROM orders o

JOIN customers c ON o.customer_id = c.id;

Update View

CREATE OR REPLACE VIEW active_customers AS

SELECT id, name, email, phone

FROM customers

WHERE status = 'active';

Drop View

DROP VIEW active_customers;

Benefits of Views

Simplify complex queries

Provide data security

Present consistent interface

Encapsulate business logic

Generate View Definitions

AI2sql creates views from your requirements.