why views are created in sql?
The main purpose of a view in SQL is thus to combine data from multiple sources in a useful way without having to create yet another database table to store that data. The multiple sources can include tables and view from other database servers.