Display the scale and precision (length) of data types like numeric and varchar in pop-up hint windows
Display the scale and precision (length) of data types like numeric and varchar in pop-up hint windows. This would be a very helpful feature to keep data types consistent throughout a database if one doesn't want to set up a user data type for each and every column that stores data types with additional parameters like, for instance, the scale and precision.
![](https://secure.gravatar.com/avatar/96127dd9a4dcb75324fe5fe65dc994a0?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
This feature was released in version 7.3 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team
-
Orlando Colamatteo commented
In addition to the information provided when hovering over a column or variable, I would also like to see the precision and scale shown in the Summary tab of the dialog offered after clicking on a table name. At present we only see "numeric" or "decimal".
-
Paul White commented
Native 2012 IntelliSense supports precision and scale for local variables at least; SQL Prompt provides no support at all.
-- Native 2012 IntelliSense reports "local variable @s numeric(10,4)"
-- SQL Prompt 5.3.2.2 reports "@s numeric (ScalarVariable)
DECLARE @s numeric (10, 4);
SELECT @s; -- hover over @s