none
SQL Azure Temporary Table Schemas

    Question

  • I have a process that I am trying to port to SQL Azure using the tempdb schema.

    For example:

    SELECT    object_id, name FROM   tempdb.sys.tables

    However, although you can create temporary tables in SQL Azure, tempdb is not available. I need to access the schema for a temporary table.

    I have searched the views and objects of my database searching for a view I can use, but have been unsuccessful in finding anything.

    Where can I access the tempdb table schemas.

     

    Friday, December 03, 2010 8:56 PM

Answers

  • For example:

    SELECT    object_id, name FROM   tempdb.sys.tables

    There is a tempdb database. However, you cannot write cross-database reference tempdb.sys.tables, and there are some limitations how you can access it. So, you can create a temp table, but you cannot access it in Tempdb.

     

    Hope this helps,

    Raymond


    Raymond Li - MSFT
    Sunday, December 12, 2010 8:28 AM
    Moderator