Suggest an editImprove this articleRefine the answer for “What is a view (VIEW) in SQL?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)A **view (VIEW)** is a **virtual table** created from an SQL query's result: it **doesn't store data physically**, instead it **runs the specified query** against the source tables every time it's accessed, e.g. `CREATE VIEW active_users AS SELECT id, name, email FROM users WHERE is_active = 1`. **Key point:** views simplify complex queries, hide unnecessary fields (improving security), and help keep the data structure clean - essentially, a `VIEW` is **a saved SELECT**.Shown above the full answer for quick recall.Answer (EN)ImageA **view (VIEW)** is a **virtual table** created from an SQL query's result. It **doesn't store data physically**, instead it **runs the specified query** against the source tables every time it's accessed. ### Example ```sql CREATE VIEW active_users AS SELECT id, name, email FROM users WHERE is_active = 1; ``` Now you can use it like a regular table: ```sql SELECT * FROM active_users; ``` ### Advantages - simplifies complex queries, - hides unnecessary fields (improving security), - helps keep the data structure clean. Essentially, a `VIEW` is **a saved SELECT** that makes working with data more convenient and clear.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.