Hi Friends,

Yesterday I published one article “How to find column related detailed info for any table?” In that article i talked about an interesting way to get column related info, but in that query you were not able to get Data-type related info. The View gives you only data_type ID. Now there is another view which has all info about all available datatypes in SQL Server.

By this time you must have realized how we will get this info, yes, we will join both these tables to get the info in one shot.

Use the below mentioned query to the desired output.

This is how it shows the output.

1_SQL_Server_An_Interesting_way_to_get_column_related_Part2 info



Sarabpreet Anand

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter  |  Follow me on FaceBook