Cloud & SQLSailor

1. Permanent Table
2. Temporary Table
3.Table Variable

Permanent table is our normal table which we create from Create Table Table Name command,however Temp are of two types :

a) Local Temp Table – Which will be available for view to the user who created the same and will be dropped after the connection is closed.

Create Table #TableName is the syntax.

b) Global Temp Table – Which will be available for all the users.

Create Table ##TableName is the syntax.