• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

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?
0
Nemetona
Asked:
Nemetona
1 Solution
 
jmcmunnCommented:
SELECT * FROM information_schema.columns

When run against your database should give you what you want.
0
 
NemetonaAuthor Commented:
Thank you
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now