Types of Transact-SQL Table Objects

There are Five Types of Transact-SQL Table Objects

#	Type	Scope
1	Standard Table	Available within the system until explicitly deleted
2	Temporary Table	Available within the system while the current database session is open
3	Table Variable	Available within a script while the current batch is executing
4	Derived Table	Available within a statement while the current statement is executing
5	View	Available within the system until explicitly deleted

Note: 

• Derived Tables are select Statements in from clause, referred by an alias name.
• CTE (Common table expression) is a type of derived table.