Views are database objects that behave like stored queries or virtual tables. There are several types of views, and they differ in internal design and purpose:
Standard SQL Dynamic
Temporary (CTEs—Common table expressions)
INFORMATION_SCHEMA
Indexed
Partitioned