2 results found
A shortcut to implement the autofix changes.
Would be nice if it wasn't necessary to use the mouse when applying autofixes.
It is almost there; you can press ctrl and get the error window and even just press enter then, to apply the fix. But the window stays and there is no reason to actually open the window, the fix could/should just be applied4 votes
We added the ability to autofix issues using the Alt + Enter keyboard shortcut in SQL Prompt 10.1.
If you have a table declared like this:
Declare @Test table
(TheKey int Primary Key,
SomeData varchar(10) Not Null)
I am told that for "TheKey" "[NOT] NULL option is not specified in CREATE/DECLARE TABLE statement" defined. But, a Primary Key can never be null, so it is NOT NULL by nature.
So, when performing Code Analysis and the parser sees "Primary Key", "Not Null" should be inferred also.2 votes
I’m pleased to announce this issue was fixed in version 9.4.10 of SQL Prompt. You can access the latest version from https://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for bringing it to our attention!
The Prompt Team
- Don't see your idea?