Question: what is difference between temp table and view in sql?
Answer: 1 Answer. The main difference between temporary tables and views is that temporary tables are just the tables in tempdb, but views are just stored queries for existing data in existing tables. ... But temporary table needs to be populated first, and population is the main preformance-concerned issue.