Saturday, February 27

Temporary table and there types

Temporary table name is limited to 116 characters. Local temporary table created with single # and then name of table. And this table is to be deleted explicitly and if it is created in store procedure it will be dropped at the end of store procedure. On the other hand if are talking abut Global variable tables start with ## and these are dropped on the session ends.
And some more facts about the Temporary tables is that these cannot be partitioned and we cannot create key constraints to these tables and one more thing is that we cannot create user-defined data types in tempdb.

No comments: