Posts

Showing posts from 2017

Named Constraints on Temp Tables

Image
Momma sed don't name constraints on temp tables. But why?

How SQL Makes Temp Tables Globally Unique

When you first build a temp table, SQL stores the definition of that temp table away  and every subsequent time you create it, it's actually a clone of that one, original table definition. To allow each individual connection to create a clone of the table, it has to do something about the name so that it won't collide with itself. Let's see what that looks like