What are the different types of tables in SQL ? Here are some facts


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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s