SQL Prompt 10

Automatically Fixing Issues

As an extension to Code Analysis, SQL Prompt allows you to automatically fix certain issues that are present in your code.

Currently, SQL Prompt supports the automatic fixing of the following issues:

When you left-click an issue present within your code, a light bulb icon will appear in the sidebar:

 Issues that are automatically fixable

 Issues that cannot be fixed automatically

When you click on the light bulb, a menu appears that allows you to apply a fix (when applicable), show more details about the issue, or see a list of all issues in the script.

Note that some fixes will require you to enter additional information. For example, after applying the fix for issue BP006: TOP without ORDER BY, you will need to type the name of the column or expression that you want to use to sort your results.

Didn't find what you were looking for?