mister magoo i have a kinda-sorta solution i use for that issue; instead of a drag and drop, i have a keyboard shortcut in SSMS that i call on any highlighted text (so it assumes a table)
i created this simple proc and mark it as a system proc in master:
CREATE PROCEDURE sp_colz @Tablename sysname
FROM sys.tables t
Columns = STUFF((SELECT ',' + quotename(name)
FROM sys.columns sc
WHERE sc.object_id = s.object_id
FOR XML PATH('')),1,1,'')
FROM sys.columns s
) sq ON t.object_id = sq.object_id
WHERE t.name =@Tablename
--mark it as a system object so it functions against the currently-scoped-databases sys.tables/sys.columns
EXECUTE sp_ms_marksystemobject 'sp_colz'
then i add a keyboard shortcut:
from there, if i was typing a query, and needed the column names, i highlight the tablename, hit control+8(in my case)
and i get the results below for a fast copy/paste.
you can see I have similar shortcuts for lots of other functions, and in total they all make me immensely more productive for things commonly looked up things like this.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!