Thursday, May 19, 2022

views and tables

 




views and tables.










ViewsTables
A view is a virtual table that is extracted from a database.A table is structured with a set number of columns and a boundless number of rows.
A view does not hold data itself.A table contains data and stores it in databases.
A view is utilized to query certain information contained in a few distinct tables.A table holds fundamental client information and cases of a characterized object.
In a view, we will get frequently queried information.In a table, changing the information in the database changes the information that appears in the view

No comments:

Post a Comment

Stored Procedure

  What is a Stored Procedure ? A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. S...