Pinal has authored 13 SQL Server database books and 40 Pluralsight courses. He holds a Masters of Science degree and numerous database certifications. Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. This way this page will be a good bookmark for the future for all of us.

If I am missing something in my script, I will modify it based on your comment. I would be very interested to see your script which lists all the columns of the database with data types. INNER JOIN sys.schemas s ON s.schema_id = ts.schema_id types AS t ON c.user_type_id = t.user_type_id If there are any user data types, it will list the same as well. Here is the updated script of this subject. It is quite possible that as time passes by my needs are changing and I change my script. I use every script which I write on this blog, the matter of the fact, I write only those scripts here which I was using at that time. It is difficult to visualize the final script when we are writing it first time. I have included few additional information which I believe I should have added from the beginning. This is one of the script which every developer would like to keep it handy.

5 years ago I wrote script SQL SERVER – 2005 – List All The Column With Specific Data Types, when I read it again, it is very much relevant and I liked it.

Sql server data types