SDU Tools: List all columns and data types in a SQL Server database

SDU Tools: List all columns and data types in a SQL Server database

One of the first things that I often do when familiarizing myself with a database, is to get a list of all the tables, columns, and data types. This immediately tells me a lot about how the database was designed.

For example, have they made newbie mistakes like using float for storing amounts of money.

One of our free SDU Tools makes this easy.

In the image above you can see the ListAllColumnsAndDataTypes procedure in use.

You tell it which database to list, and you can optionally limit it to particular schemas, tables, and/or columns. For each of these, you can specify the value ALL or you can supply a comma-delimited list of values.

You can see the tool in action here:

https://youtu.be/FlkRho_Hngk

SDU Tools are free developer and DBA tools for SDU Insiders. To find out more about SDU Tools or to add yourself to the list, visit here:

http://sdutools.sqldownunder.com

2018-03-07