Extract Temp table script from SMS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Disney - 28 Feb 2008 20:28 GMT

I have a developer request to extract script of the temp table that he
created in tempdb through SMS how would we do that

If I have created the temp table…
SELECT ‘Usernae'[Name], 32 [Age]
INTO #DELETE_ME

How can I generate a list of the columns in table #DELETE_ME

Typically I use Management Studio and right click the table and choose
“Generate Table as”…”Select To”.

Reply to this Message

Andrew J. Kelly - 28 Feb 2008 23:30 GMT

There is no way that I know of but you can just as easily select into a real
table in Tempdb and script that one. Just remember to drop the table when
done.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

>I have a developer request to extract script of the temp table that he
> created in tempdb through SMS how would we do that
[quoted text clipped - 7 lines]
> Typically I use Management Studio and right click the table and choose
> “Generate Table as”…”Select To”.

Reply to this Message