To export user-defined profiles in the Options window, click the Export button and, from the Export profiles window, select the profiles and click the OK button: In order for changes to take effect, in the Options window, click the Save button. The deleted profile will be removed from the Profile drop-down list: In the confirmation dialog, click the Yes button. To delete the profile, from the Profile drop-down list, select a user-defined profile that should be deleted and click the Delete button. To edit newly created profile information, click the Edit button, in the Edit profile window, change the information and click the OK button:ĭelete user-defined SQL formatting profile Please note, in order to formatting profile be saved for later usage in the Options window, click the Save button otherwise, the newly created profile won’t be saved.Įdit user-defined SQL formatting profiles When everything is set, click the OK button: Optionally, you can add an author name of the profile and the description of an additional explanation of the profile. To create a completely new formatting profile, click the New button and under the Create profile window, enter a name for a profile. When all is set, click the OK button, and the newly copied profile will appear in the Profile drop-down list: Under the Copy profile window, if needed the name, author, and description can be changed: To create a new profile from an existing built-in or user-defined profile, from the Profile drop-down list, choose the profile which should be copied and click the Copy button:

The similar message will appear if you try to delete a built-in formatting profile: For example, if you try to change some settings the following message will appear: These four profiles cannot be changed in any way. Hello, and welcome to this video presentation in which we will introduce how to use ApexSQL Refactor SQL formatting profiles and is a guide through the process of managing SQL formatting profiles.įour built-in profiles come with the installation of ApexSQL Refactor which can be used to format your SQL code:

In this article, we will introduce how to use ApexSQL Refactor SQL formatting profiles and is a guide through the process of managing SQL formatting profiles.

Apex sql refactor