Last answered:

10 Jul 2023

Posted on:

08 Jul 2023


Resolved: What is the difference between VIEWS and Stored Procedure?

Where both serve as a shortcut to display a specific query

1 answers ( 1 marked as helpful)
Posted on:

10 Jul 2023


Hi Mohamed!
Thanks for reaching out.

A view is intended to be regarded similarly to a table, it gives an overview of combination of data from different tables. A routine can also include different operations than just reading data, it could also be used for other CRUD operations like insertion, updating or deleting data. You cannot do that with a view.

A view represents a virtual table. You can join multiple tables in a view and use the view to present the data as if the data were coming from a single table.

A stored procedure uses parameters to do a function. It can be updating and inserting data, or returning single values or data sets.

Hope this helps.

Submit an answer