Question

Difference between tables and view in Dbms​

Answer 1

${\huge{\sf{\green{\underline {\underline {Question : }}}}}}$

Difference between tables and view in Dbms ?

${\huge{\sf{\pink{\underline {\underline {Answer }}}}}}$

The main difference between view and table is that view is a virtual table based on the result set of an SQL statement, while a table is a database object that consists of rows and columns that store data of a database.

Generally, RDBMS is a software that helps to create and manage databases which are designed according to the relational model. Additionally, MySQL, MSSQL etc. are some popular RDBMSes. A developer can create various operations on the data stored in databases using the Structured Query Language (SQL). It is possible to insert, update, select and delete data as well as perform advanced operations such as stored procedures and triggers using SQL. Furthermore, in the context of RDBMS, there are various database objects. Two of them are view and table. Overall, the view depends on the table. In other words, there should be one or multiple tables to create views.

A database is a digital collection of organized data or information which can be stored in computer memory or other storage devices. It was developed in such a way that large amounts of data can be stored and accessed by users. A database has several objects that save, display, and analyze large amounts of information. Microsoft SQL provides database objects such as stored procedures, users, functions, tables, and views.

_______________________________

Hope it helps you :)

Answer 2

The main difference between view and table is that view is a virtual table based on the result set of an SQL statement, while a table is a database object that consists of rows and columns that store data of a database.

Generally, RDBMS is a software that helps to create and manage databases which are designed according to the relational model. Additionally, MySQL, MSSQL etc. are some popular RDBMSes. A developer can create various operations on the data stored in databases using the Structured Query Language (SQL). It is possible to insert, update, select and delete data as well as perform advanced operations such as stored procedures and triggers using SQL. Furthermore, in the context of RDBMS, there are various database objects. Two of them are view and table. Overall, the view depends on the table. In other words, there should be one or multiple tables to create views.

A database is a digital collection of organized data or information which can be stored in computer memory or other storage devices. It was developed in such a way that large amounts of data can be stored and accessed by users. A database has several objects that save, display, and analyze large amounts of information. Microsoft SQL provides database objects such as stored procedures, users, functions, tables, and views.