how can I print out the table designs for all the tables in my database

I would like to get a print out of the name and type of all my fields in all my tables from sql server 2012.  

I know I can do this if I go to each table in turn but is there a command that will let me do this for all the tables at once?
Who is Participating?
jmcmunnConnect With a Mentor Commented:
SELECT * FROM information_schema.columns

When run against your database should give you what you want.
NemetonaAuthor Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.