What is Virtual tables in SQLite.


Q.68 What is Virtual tables in SQLite.?Ans:-

  • Virtual tables can be used to connect any data source to SQLite, including other databases.
  • A virtual table is created with the CREATE VIRTUAL TABLE command.
  • Virtual tables cannot be made temporary, nor do they allow for an IF NOT EXISTS clause. To drop a virtual table, you use the normal DROP TABLE command.

Kalavati Technologies Pvt Ltd