SQL Tables and Views: What's the Difference?

If you find this SQL tutorial useful please LIKE and SUBSCRIBE!

What's the difference between a table and a view? This is quite a common database interview question, and also a fundamental relational database concept.

00:00 - Introduction
00:11 - Tables
00:30 - Views
01:45 - Editing views
02:12 - Advantages of views
03:00 - Disadvantages of views
03:47 - Optimising view performance

In this video I explain the similarities and differences between tables and views. I also explain some uses for views. Views are supported by many relational databases including SQL Server, MySQL, MariaDB and PostgreSQL.

Views mythbusted: https://www.sqlservercentral.com/blog...

Do you make much use of views? Let us know in the comments section below. I used to use database views a lot but I've neglected them a lot since I switched from using SQL Server to MySQL.

Don't forget to subscribe for more SQL tips tutorials.