sp_help 'Table Name' throws out many layers of information. This would be ideal for just checking one table at a time just to get information.

What we need is a way to get the "CREATE TABLE ABC ( mo VARCHAR(10) )" definition in text form.

This way, via SSIS, I can save all definitions to a text file.