Click here to Skip to main content
12,753,809 members (33,669 online)
Click here to Skip to main content
Articles » Database » Database » SQL Server » Revisions


7 bookmarked
Posted 19 Jul 2013

List All Tables and Columns in a Database

, 20 Jul 2013 CPOL
This query will show you all tables and columns in a database, and it can be pasted into Excel for easy manipulation.



Compare Revision Minor Date Status Editor
3 - publicly available No 20-Jul-13 2:58 Available AspDotNetDev
Added info about the command to indicate the database.
2 No 19-Jul-13 3:45 Available AspDotNetDev
Converted to tip.
1 No 19-Jul-13 3:32 Available AspDotNetDev
Initial creation


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Web Developer
United States United States

  • Managing Your JavaScript Library in ASP.NET (if you work with and you don't read that, you are dead to me).

  • Graduated summa cum laude with a BS in Computer Science.

  • Wrote some articles and some tips.

  • DDR ("New high score? What does that mean? Did I break it?"), ping pong, and volleyball enthusiast.

  • Software I have donated to (you should too):

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170217.1 | Last Updated 20 Jul 2013
Article Copyright 2013 by AspDotNetDev
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid