Different types of SQL tables


  1. Permanent tables (i.e., created using the create table statement)
  2. Derived tables (i.e., rows returned by a sub-query and held in memory)
  3. Temporary tables (i.e., volatile data held in memory)
  4. Virtual tables (i.e., created using the create view statement)

Comments

Post a Comment