Is there a way to quickly draw a summary of a table 1

[eo]

Something that will show me the fields of a table and their data types and lengths. I need to do a union join between 4 tables which are similar, but not quite. If I can draw such lists, it will make my life much easier, as I will be able to compare on paper then do my union

EO
Hertfordshire, England

 

[SQLBI]

Hi,

sp_help will show you the info you're after, just add the name of the object.

USE AdventureWorks
GO

sp_Help [Production.Product]

HTH.

Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem