midT-SQL
What is a VIEW in SQL Server?
Updated May 17, 2026
Short answer
A virtual table based on a query.
Deep explanation
Views simplify complex queries and improve security.
Real-world example
HR reporting layer.
Common mistakes
- Using views for heavy computations.
Follow-up questions
- Are views stored?
- Can views be indexed?