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 http://www.red-gate.com/messageboard/viewforum.php?f=169.

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. Bulk Smart Rename

    Enhance Smart Rename to accept a list of name changes.

    Even if it runs the existing smart rename and concatenates the scripts it would save a lot of data entry time versus doing each change one at a time.

    You should require fully qualified names in the import data to avoid ambiguity errors.

    44 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      6 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
    • Include MERGE statement in smart rename

      When one would like to smart rename a column, the smart rename function does not update a MERGE statement. Could this be added to the smart rename feature?

      11 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
      • Smart Rename should include renaming a Schema

        Self explanatory... Need to right-click a user-defined schema and be able to generate a script that effects the scema rename and code within all affected objects. Would be great to add a list of additional databases in which to look for candidate objects to change: triggers, SPs, UDFs...

        9 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
        • order by

          When Ordering by column numbers, formatting the SQL would replace the column number with the qualified column name. e.g.

          Order By 1,2,3,4 would be come
          Order By t.TerritoryName,
          d.DivisionDescription,
          r.RegionDescription,
          s.Name

          8 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            1 comment  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
          • Smart Rename to change case

            sometimes I need to just change the casing of letters in a field name (e.g. a field has GUID and I want to make it Guid). smart rename does not allow me to change the name if the new name is exactly the same saying that a column with this name already exists.

            so I change the name to GuidXXXX and then on the generated script remove the XXXX and the script runs just fine.

            I think smart rename should not warn that the name exists if I am just changing casing of the name

            6 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
            • External database dependencies

              Smart Rename should find and resolve external database dependencies.

              5 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                3 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
              • Smart Rename does not update when used in cursors.

                **BUG** - I ran a smart rename on all of my tables to change from TableName to tblTableName. I did this for ~15 tables and everything looked fine until I ran the code. Many of my stored procedures us cursors, and I found that none of my cursors were updated with the new table names.

                Notice:
                ```sql
                SET @myCursor = CURSOR FOR SELECT MyField FROM dbo.MyTable WHERE MyFlag = 1
                ```

                Run [Smart Rename...] on MyTable to change it to tblMyTable.

                Notice that the cursor definition does not get changed.

                4 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                • Rename objects within a string

                  I want to be able to rename objects that appear in strings within a script. For example, if I am renaming dbo.sometable, I want it to see and update a script that contains "Exec sp_someproc 'dbo.sometable'".

                  4 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                  • Smart Rename - just do it button

                    How about when doing a Smart Rename you offer a Just Do It (all apologies to Nike!) button? Clicking on this would run the script in the background using OSQL/SQLCMD/whatever and do the rename.

                    Often if I am doing a lot of renaming I have a lot of scripts open and I’m uncertain as to whether or not I’ve run them or not.

                    You can still warn people, although I would be happier if this was a configurable option (‘Warn before using Just Do It button in Smart Rename’)

                    3 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                    • smart rename

                      Please add an option to propogate a name change down through the dependency hiearchy. If I change a column name, I would prefer the view/function not keep the old name as an alias, even if this means my rename script will have to touch many more items.

                      I would hope this could work similar to SQL Compare where there is an additional check box to script dependent items.

                      Smart rename is great, but I don't want to have to run it multiple times to rename a single column across all of my objects.

                      3 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        1 comment  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                      • Refactor - rename column aliases

                        Renaming column aliases is not working and it might be very useful feature. Lets see following example:

                        SELECT Totals.Sales
                        FROM (SELECT 5 AS Sales) AS Totals

                        If You press F2 on table alias [Totals] it works perfectly. However if You need to change alias of column [Sales] and You will press F2 nothing happens beside proper highlighting of this column name.

                        2 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                        • Make the schema list in Smart Rename alphabetically sorted

                          THe schema list in smart rename is currently unsorted, it would be a lot quicker to use (when changing an objects schema) is this were sorted alphabetically.

                          2 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                          • Smart Rename to include open scripts

                            I do all of my work in script and would like the option to "Smart Rename" references in my open scripts rather than just installed objects.

                            2 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                            • Smart Rename via Synonym

                              Being able to have Smart Rename also generate a synonym of the old name, pointing to the object with the new name, would be very useful in scenarios where there is external code pointing to specific database objects that you're renaming.

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                              • Refactor: ability to update a tag or property name inside the existing data of an xml column

                                SqlPrompt smart rename is a good refactor tool.
                                With the new xml columns we often store some "relational" data inside them.

                                xml data has implicit schema definition, and modifying a tag name should modify the name for all existing data in the same column.

                                For explicit schema definition this is very easy.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                                • Propagate smart-rename through foreign key hierarchy

                                  For example, if table Person has Person_ID, and table Employee also has Person_ID which has a foreign key relationship to Person.Person_ID, then I smart-rename Person.Person_ID, it would be spectacular if Employee.Person_ID was also similarly renamed.

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                                  • right click object >> transfer schema

                                    as I develop new databases, i always find myself fine tuning my naming conventions and re-organising my objects based on schemas. it would be nice to have a right click option to change the schema much more quickly.

                                    For example, instead of writing the following statement

                                    ALTER SCHEMA HumanResources TRANSFER Person.Address;

                                    i would just right click Person.Address >> Change Schema >> (and then pick HumanResources from a list)

                                    being able to select multiple objects and do this would be a bonus

                                    1 vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                                    • smart rename

                                      My suggestion is to add support for Smart Rename of a database. It would update objects (procedures, views, functions, etc) that reference fully qualified objects. This would be very handy when database name changes due to new naming standards or other reasons.

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Don't see your idea?

                                      Feedback and Knowledge Base