What is a virtual table in SQL?

devquora
devquora

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mssql Interview Questions

    What is MSSQL?

    MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..

    Mssql Interview Questions

    What is SQL server agent and what are the two modes of authentication in SQL Server?

    SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..

    Mssql Interview Questions

    What is SQL Profiler?

    It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..