Difference between View and Table in SQL
1. A table contains data, a view is just a SELECT statement which has been saved in the database.
2. The adventage of a view is that it can join data from several tables thus creating a new view of it.
3. Recommand use View to make report then SELECT * FROM view instead of the complex query.
この記事が気に入ったらサポートをしてみませんか?