Global Temp Metadata

• Corey Henschel

  SSC Enthusiast

  Points: 183

  More actions

  June 12, 2008 at 11:41 am

  #187878

  In SQL 2005.

  I have a global temp table ##data. It is created dynamically and the column list is also dynamic.

  I need to pass this table name to a stored proc and then retrieve the column list in that stored proc. Because of legacy coding issues, I would prefer not to pass the column list as a parameter. The information_schema.columns view contains all the of the columns for the regular tables in the database. Is there a similar listing of the columns for global temp tables that I can query?

  Thanks in advance

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  June 12, 2008 at 12:00 pm

  #828038

  Just look in the TempDB database:

  CREATE TABLE ##tmpMyTable (FieldA INT, FieldB VARCHAR(10))

  SELECT * FROM TempDB.Information_Schema.Columns WHERE Table_Name = '##tmpMyTable'

• Corey Henschel

  SSC Enthusiast

  Points: 183

  More actions

  June 12, 2008 at 12:03 pm

  #828043

  TYVM! :w00t:

  I had found references to tmpDB and the temp database but neither of those seemed to work.