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 or our support portal.

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. Azure SQL Database Smart Rename support

    Smart rename doesn't work on Azure SQL Database without creating a SQL login to use for the task. Be nice to support connections via Active Directory Password, or any of the other Azure AD auth options.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
  2. Smart Rename auto-generate synonym

    It would be incredibly useful to have Smart Rename have the option to generate a synonym that points the old name to the new one, in order to maintain functionality for any legacy applications accessing the database via those old object names.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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?

    12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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...

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    54 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →

    No progress to report yet, but the team will be reviewing this suggestion along with other possible bulk/batch operations for Prompt as part of a roadmap review this month.

  • Don't see your idea?

Feedback and Knowledge Base