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.
SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..