News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud



SQL Server: How do look at the dataypes/lengths of columns in a temp table?

To view that information, there are 2 primary ways:

select * 
from tempdb.INFORMATION_SCHEMA.COLUMNS
where table_name like '#MyTempTable%'
select * from tempdb.sys.columns where object_id = object_id('tempdb..#mytemptable');

Thursday, May 17, 2018 1:45 PM

Feedback

No comments posted yet.


Post A Comment
Title:
Name:
Email:
Comment:
Verification: