CODEWITHSUNDEEP
sql-serverssmsdeveloper-toolsssms-2012ssms-addin
Daniel E.
Daniel E.

Reputation: 2059

Is there a way to expand the column list in a SELECT * from #Temp_Table in SSMS?

As seen here LINK you can hover over the * in a SELECT * from... and a tooltip will come up with a list of the columns represented by that *.

Is there a way to copy the text from the tooltip to the clipboard?

I know that you can use the columns folder in the object explorer to generate a list of columns by dragging it into the query editor window, but this cannot work for temp tables as they do not appear in the object explorer.

EDIT

For completeness sake, the answer below "You can right-click on the table in Object Explorer and select Script Table as->CREATE to->New Query Editor Window." is also not workable for the same reason as above.

END EDIT

I do not see a way to do this in SSMSBoost, which is an add-on for SSMS that I use. (The only reason I mention it is I am pretty sure I have seen the SSMSBoost developers on SO, feature request??)

EDIT 2: Is there any other way to quickly expand the * in a SELECT * from #Temp_Table without actually running the code to create the temp table? END EDIT 2

Upvotes: 14

Views: 16499

Answers (5)

Lauren Oldja
Lauren Oldja

Reputation: 622

If you have RedGate SQL Prompt, you can expand wildcards using Ctrl + B, Ctrl + W

Upvotes: 2

user3885999
user3885999

Reputation: 1

The way I usually do this is by highlighting the table name and hitting Alt + F1. Then, you can copy-paste the Column_name values.

Upvotes: -1

Nader
Nader

Reputation: 157

You can just drag the column's subfolder from the object explorer into the editor and the columns will be added as a list.

Upvotes: 14

wergeld
wergeld

Reputation: 14442

Very similar to this question. Here is the accepted answer from that question:

select * from tempdb.sys.columns where object_id =
object_id('tempdb..#mytemptable');

Upvotes: 2

lbarreira
lbarreira

Reputation: 170

You can right-click on the table in Object Explorer and select Script Table as->CREATE to->New Query Editor Window.

The information you want in near the top of the script this command creates.

Upvotes: -1

Related Questions