<div>
Actually figured it out... had to get it to drop the brackets in the original temp table &nbsp;name.
</div>


<div>
<div class="content wysiwyg-content">
I'm creating a global temp table using a random id and then trying to get column names from that table using INFORMATION_SCHEMA. Below is an example of what I'm doing --<br />
<br />
SELECT 'JOHN' AS FIRST_NAME,'DAVIS' AS LAST_NAME &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,'CHICAGO' AS CITY INTO &nbsp;[##E0404FF442A04AC7BCCEC33<wbr />79FBC63]<br />
<br />
select column_name from TEMPDB.INFORMATION_SCHEMA.<wbr />COLUMNS where TABLE_NAME='[##E0404FF442A<wbr />04AC7BCCEC<wbr />3379FBC63]<wbr />'<br />
This does not work, it returns nothing under column_name. &nbsp;I can take that same table and copy it into another temp table, and it works. &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
SELECT * INTO ##OUT_LABEL FROM [##E0404FF442A04AC7BCCEC33<wbr />79FBC63]<br />
<br />
select column_name from TEMPDB.INFORMATION_SCHEMA.<wbr />COLUMNS where TABLE_NAME='##OUT_LABEL'<br />
<br />
column_name<br />
FIRST_NAME<br />
LAST_NAME<br />
CITY<br />
<br />
What am I missing here on why this is not working???
</div>
</div>


I'm creating a global temp table using a random id and then trying to get column names from that table using INFORMATION_SCHEMA. Below is an example of what I'm doing --

SELECT 'JOHN' AS FIRST_NAME,'DAVIS' AS LAST_NAME	,'CHICAGO' AS CITY INTO  [##E0404FF442A04AC7BCCEC3379FBC63]

select column_name from TEMPDB.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='[##E0404FF442A04AC7BCCEC3379FBC63]'
This does not work, it returns nothing under column_name.  I can take that same table and copy it into another temp table, and it works.  	

SELECT * INTO ##OUT_LABEL FROM [##E0404FF442A04AC7BCCEC3379FBC63]

select column_name from TEMPDB.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='##OUT_LABEL'

column_name
FIRST_NAME
LAST_NAME
CITY

What am I missing here on why this is not working???

Actually figured it out... had to get it to drop the brackets in the original temp table  name.

Select column_name from INFORMATION.SCHEMA.COLUMNS not working with TEMP tables

I&#39;m creating a global temp table using a random id and then trying to get column names from that table using INFORMATION_SCHEMA. Below is an example of what I&#39;m doing --

SELECT &#39;JOHN&#39; AS FIRST_NAME,&#39;DAVIS&#39; AS LAST_NAME	,&#39;CHICAGO&#39; AS CITY INTO  [##E0404FF442A04AC7BCCEC3379FBC63]

select column_name from TEMPDB.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=&#39;[##E0404FF442A04AC7BCCEC3379FBC63]&#39;
This does not work, it returns nothing under column_name.  I can take that same table and copy it into another temp table, and it works.  	

SELECT * INTO ##OUT_LABEL FROM [##E0404FF442A04AC7BCCEC3379FBC63]

select column_name from TEMPDB.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=&#39;##OUT_LABEL&#39;

column_name
FIRST_NAME
LAST_NAME
CITY

What am I missing here on why this is not working???

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.