1. Permanent Table
2. Temporary Table
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.