What are the challenges you face when working across database platforms? Take the survey
Options

ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER

bstrautinbstrautin Posts: 8 Bronze 2
edited February 27, 2014 12:40PM in SQL Prompt Previous Versions
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.

Comments

  • Options
    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
    Product Support
    Red Gate Software
Sign In or Register to comment.