tags: 📥️/📰/🟥️ publish: true aliases: - The Misconception of Views in SQL cover: '![rw-book-cover](https://readwise-assets.s3.amazonaws.com/static/images/article2.74d541386bbf.png)' general_subject: specific_subject: source: medium isbn: doi: url: 'https://medium.com/p/92fa9fe8b89b' author: "[[@Eason Liaw Yi Xian]]" guest: publish_date: reviewed_date: --- ![rw-book-cover](https://readwise-assets.s3.amazonaws.com/static/images/article2.74d541386bbf.png) ## Highlights - Aren’t views and tables in SQL both mean that the output from those queries is in a structured tabular format? While that is undeniably true from an end user’s perspective, there is a subtle difference between both terminologies that non-SQL experts tend to mix up. Tables in SQL are database objects that contain data itself in a structured manner, while views in SQL are database objects that represent saved SELECT queries in “virtual” tables.