Options
Computed columns in table variables underlined in green
DBAJohnny
Posts: 28 Bronze 2
in SQL Prompt
When I include a computed column in a table variable, SQL Prompt 9 and later underlines it in a green squiggly line with the tooltip [NOT] NULL option is not specified in CREATE/DECLARE TABLE statement.
Computed columns do not use the [NOT] NULL construct....
Can this be corrected?
Computed columns do not use the [NOT] NULL construct....
Can this be corrected?
Tagged:
Best Answer
-
Options
FabiolaB
Posts: 54 Silver 3
Hi @DBAJohnny,
Thank you for reporting this.
I've created a ticket for this issue (ref SP-6761).
Regards,
Fabiola
Answers
So if you fix the rule please consider to detect Null/ Not Null for persist computed columns but not for a non Persisted column.
I hope that makes sense...
Torsten
We've fixed this issue in our latest version of SQL Prompt 9.0.8.3873 (installer here).
You can find more information about this release in this forum post.
Kind regards,
Frederico
Redgate Software