How can we help you today? How can we help you today?

ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER

If a GO statement is not preceded by a newline, e.g. is first text in a query window, the autocomplete suggestions for a subsequent ALTER will exclude FUNCTION, PROC, PROCEDURE, VIEW, and TRIGGER, even though they should be included.

For example, this works as expected: 
-- anything
GO
ALTER

But this does not: 
GO
ALTER

And this does not work either: 
select top 10 * from sys.tables GO
ALTER

The popup from both cases should be the same.
bstrautin
0

Comments

1 comment

Sort by
  • Manfred.Castro
    Hi Benjamin,

    I was able to reproduce the reported behavior and have logged this issue under the internal reference number of SP-5038.

    Unfortunately I am unable to provide a definitive timeline for when this might be fixed.

    Sorry for any inconvenience this may have caused.

    Sincerely,
    Manfred
    Manfred.Castro
    0

Add comment

Please sign in to leave a comment.