Posted On: Feb 22, 2018
In SQL there is an object which is known as a virtual table, it is not stored directly in the file of the database. The virtual table allows SQLite for manipulating and accessing the resources by using a powerful language of SQL query. In other terms, the view in SQL is known as a virtual table. This view represents the columns and rows like any real table.
To create a view in SQL you can use the following syntax:
CREATE VIEW view_name AS SELECT column1, column2, . . . FROM table_name WHERE condition;
So, a virtual table doesn't exist physically in the database. It helps in defining things that can be used as the SQL statements just similar to a real table.
Never Miss an Articles from us.
MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..
SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..
It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..