I would like to see the Script Object as Alter (F12) feature to work with synonyms. However, I am aware that a synonym cannot be altered - instead I suggest to generate a script containing a DROP and a CREATE statement.

That way one could bring up the code of the referenced object by selecting the synonym, pressing F12, selecting the referenced object and pressing F12 again.

Feature to automatically add column alias with the name of the column.
E.g.:

SELECT Column1
FROM Table1 AS t1

changes to:

SELECT Column1 AS Column1
FROM Table1 AS t1

If the name can not be found add a dummy-alias like Exp1

It would be nice to have the ability to mass import/export aliases.

When you code a SELECT statement as:
SELECT EffDt AS 'EffectiveDate'
SQL PROMPT advises that string literals as column aliases have been deprecated.
Have an option to convert string literals, similar to Remove Square Brackets. In this case, Convert Column Aliases would either remove the apostrophes, where appropriate, or add square brackets if required (e.g. the alias contained special characters, a space or reserved word).

Run Script at Cursor just Oracle SQL Developer with F5 or Alt+X. Please implement this very helpful functionality.

When typing a string of text within a quote, do not replace my text with objects from the database.

COLUMNPROPERTY (https://docs.microsoft.com/en-us/sql/t-sql/functions/columnproperty-transact-sql) is missing two suggested property values that were introduced along with System-Versioned tables in SQL Server 2016.
Please find the missing values below:

 GeneratedAlwaysType

 IsHidden

Currently, when hovering over table objects, and clicking on the table name mini popup, you get the object definition box, with a 'Script' and 'Summary' tab.

The 'Script' tab has the table and index creation scripts, and the 'Summary' tab lists the column definitions.

For tables with triggers, it would be nice to have a 'Triggers' tab that contains
any trigger scripts for the table.

https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/using-the-object-definition-box-and-object-tooltips

When you select a table from the intellisense list
Precede the table name with the database name as well
Currently it is only inserting the schema name in front of the table name
i.e. dbo.<table name>

It should be <database name>.<schema name>.<table name>

When working with views, you lose the intellisense for columns. It would be nice if SQL Prompt could get the MS_Description value for the view column from the underlying base table for the view.

We use a data warehousing strategy that creates potentially dozens of tables for multi-class entities in the data warehouse, so we have many tables that end in "core". This leads SQL Prompt to alias the object with a final "C" that we then remove manually. For example, our InstanceCore and Database_Core tables are aliased to "IC" and "DC" when we would prefer "I" and "D" respectively.

Can SQL Prompt's Aliasing capabilities be extended to support "Suffixes to ignore" just like the existing "Prefixes to ignore"?

After Update to 10.0.
When you for example press J for join and confirm this input with Tab, it wont add a Space. You have to add this space manually :(
maybe it is possible to add automatily always the space

Similar to the movement of caret within CamelCase, could you please enable such behavior for pythoncaseidentifiers? I'd like the caret to stop in these places when using CTRL+<right or left arrow>: (1)python(2)case(3)identifier. Would that be possible, please?

Hi there. Currently, SQL Prompt formats an invocation of a sproc like this:

exec sproc @param1 = ?,

@param2 = ?,

@param3 = ?

I'd like to be able to change this into:

exec sproc

@param1 = ?,

@param2 = ?,

@param3 = ?

Thanks.

When formatting SQL, it would be good to have the option to put the item following an AND/OR on a new line and align it, so instead of:

WHERE

OutgoingResults.LoadDateKey = 20191106

AND OutgoingResults.FeedName = 'TestFeed'

we have

WHERE

OutgoingResults.LoadDateKey = 20191106

AND

OutgoingResults.FeedName = 'TestFeed'

Do you think it's possible to only have the refresh of suggestions the first time a database is loaded (so skip refresh if the cache already exists, but let the possibility to manually refresh cache for this db with the contextual menu of course)

We have hundred of databases (with thousands of view and sp) and sql prompt try to refresh all the time the same databases (for example when we restart Management Studio) and nothing never change in these databases ...

So we would like to load schema automatically only the very first time and then on demand.

Thanks

Add ability to add or remove square brackets without having to edit the settings for which direction you want it to go.