Click here to Skip to main content
11,805,316 members (66,372 online)
Click here to Skip to main content
Articles » Database » Database » SQL Server » Statistics
Add your own
alternative version

List All Tables and Columns in a Database

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




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...

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