SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums at https://forum.red-gate.com/categories/sql-prompt

How can we improve SQL Prompt?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Qualify Object Names case correction works in SSMS but not Visual Studio

    I am addressing the warnings for "Validate casing on identifiers". When I use Ctrl-Q Ctrl-B in SSMS, the objects are qualified and even casing is corrected on the object. However, when doing this same task in Visual Studio, object case correction is not performed. Please correct this.

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
    • Inserted code=> Qualification - Don't want qualify object names with owner n

      I really love the 2 options to qualify object names with owner name and qualify column nmaes with table name.

      BUT when I select a column name through intellisense, I don't want to qualify the table name with the owner (schema).

      For example If the 2 qualify options are checked and if I use the intellisense to input text :

      SELECT
      dbo.Person.Name ==> KO, I woulid like to have Person.Name
      From
      dbo.Person ==> OK

      I start to type the name of the table, select the table suggested by intelllisense and then select the column so when I select the table…

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
      • Add option to not qualify fields in the SET clause of an UPDATE statement

        PRE-REQUISITE: Under "Options > Inserted Code > Qualification", enable both "Qualify column names with..." options.

        When specifying the columns in the SET clause of an UPDATE statment, auto-complete qualifies each column with alias/name of the table that is to be updated. Please include an option to not qualify the column names being SET an UPDATE. Columns used in expressions should still be qualified.

        =================================================
        Example 1: simple update
        -------------------------------------------------
        -- instead of this:
        -------------------------------------------------
        update ExampleTableA
        set ExampleTableA.Field1 = 'a value',
        ExampleTableA.Field2 = 'another value';

        -------------------------------------------------
        -- do this
        -------------------------------------------------
        update ExampleTableA
        set Field1 = 'a value',
        Field2 = 'another…

        3 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
        • Disable Performance Rule PE001 (Schema Name for procedures is not specified) for System Stored Procs

          There should be an option to disable Performance Rule PE001 for system stored procedures.

          Generally speaking we like to prefix calls to "our" stored procedures with the schema name, so this rule is a nice feature. However, in cases where we make calls to system stored procedures (e.g. EXEC sp_set_session_context) I'd like to not be warned or notified that we're missing the schema name.

          We use a feature in SQL Server (Row Level Security) that requires the use of sp_set_session_context in every script we execute, so having PE001 enabled creates a situation where we see warnings that aren't helpful.

          However,…

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
          • Add option to make table aliases not bracketed

            I would like the ability to automatically put brackets around all SQL objects, except for table/function aliases

            Example

            SELECT
            A.[Foo],
            B.[Bar],
            [Foobar] = A.[Foo] + B.[Bar]
            FROM
            [dbo].[MyTableA] A
            CROSS JOIN [dbo].[MyTableB] B

            instead of the current all or nothing of

            SELECT
            [A].[Foo],
            [B].[Bar],
            [Foobar] = [A].[Foo] + [B].[Bar]
            FROM
            [dbo].[MyTableA] [A]
            CROSS JOIN [dbo].[MyTableB] [B]

            4 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
            • no double AS table alias

              I have the following statement:
              SELECT * from dbo.table1 AS t1

              The option to auto-apply table aliases (including AS) is enabled

              When I change table1 to e.g. table1_details (using code completion) it changes my query to

              SELECT * from dbo.table1_details AS td AS t1

              which is syntactical incorrect (because of the double AS)
              -> please either skip the add-alias (if there is already one) or change the existing alias to the new one

              I'd prefer if you would not add another alias because sometimes I want to run the same query (same columns in the WHERE condition) for different tables…

              4 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
              • Fix issue related to incorrect results from "Qualify Columns Names with Aliases" when Pivot/Unpivot is involved.

                I ran into an issue today where the automatic qualifying of colun names when an unpivot table was being referenced resulted in an incorrect qualifying alias name being applied to a column. The resulting SQL did not execute correctly and SQL Prompt actually introduced a bug in my code that was troublesome to find and fix. After fixing the code the first time by removing the incorrect alias, I determined it was SQL Prompt that was the culprit because after reformatting the code the bug was present again. I had to prefix the columns with the correct prefix to prevent…

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                • Configurably include table hints when auto-completing a table

                  For a specific database/server, automatically append configurable table hints (or free text) such as with(nolock) to any table name that is auto-completed.

                  3 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                  • Datetime columns

                    Can we see columns and their datatypes in SQL Prompt intellisense for a table ordered by datatype rather than column? We're in an ETL environment and would like to see all datetime columns for a table in a row for example.

                    2 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                    • Option to include the schema when generating an alias.

                      I have tables that repeat in different schemas, for example Supplier.Location and Customer.Location. I'd really like auto-alias to include the schema when generating the alias. Supplier.Location should be SL and Customer.Location should be CL. Instead I end up with L and L2, which is not as clear.

                      Ideally, I'd prefer the schema characters to be lowercase and the table to be uppercase. Using sL and cL would make my query even more readable.

                      12 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        4 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                      • If a database is offline, it should not appear in the prompt list.

                        If a database is offline, it should not appear in the prompt list.

                        4 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                        • Option to customize order of colums or table names listed in suggested box.

                          I got 10-20 tables that starts with word citations i mostly use citations and citation_details which is way down on my list. If i could have those to at the top would be save 5 10 extra keys. Same goes with column names. Would be awesome be able sort these by most used or custom sort. And change the sorting on the spot while the list is open there is alot of space that can be added.

                          6 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                          • Specify Specific Databases on Server to examine

                            Give the user the option to select specific DB from Server as they may not have access to all. Would help avoid error with permissions

                            2 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              1 comment  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                            • Don't see your idea?

                            Feedback and Knowledge Base