Temporary Table
Table Variable
Syntax- create table #temp
Syntax- Declare @tablename Table
It support DDL operation :-like drop, create, alter etc.
It doesn’t support DDL operation.
It participate the explicitly transactions defined by the user.
It doesn’t participate in the explicit transactions defined by the user.
It doesn’t allowed in UDF
It can be used in user defined functions
It support adding indexes explicitly after table creation.
It doesn’t adding indexes explicitly.