Sample Header Ad - 728x90

SQL Management Studio - Add-on / Extension to view Column Data Type

2 votes
1 answer
312 views
Is there any way (built in) or free/paid add-on/Extension for SQL Management Studio that allows us to know exactly a data type of a column when we are writing a query? In this specific project I have had situations where by looking a the query result I am not exactly sure of the datatype, if it is a number written in a nvarchar(max) column.... or if it is a tinyint, or int, or bigint, etc.... And I am spending so much time just to drill on the "tree list" to reach a speficic table and expand the Columns node to find out what am I dealing with.... A situation when you have bunch of JOINS (and allias) and sp_help would require me always to go to some other query window and type more sql (table names).... then it would be **easier and faster just to have like a tooltip message of the column with extra info.**
Asked by Dryadwoods (211 rep)
Mar 21, 2018, 09:47 AM
Last activity: Jun 12, 2018, 08:54 AM