|
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.
|