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

Posted on 2013-06-24
Medium Priority
Last Modified: 2013-06-24
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?
Question by:Nemetona
LVL 12

Accepted Solution

jmcmunn earned 2000 total points
ID: 39271419
SELECT * FROM information_schema.columns

When run against your database should give you what you want.

Author Closing Comment

ID: 39271449
Thank you

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question