Importing and exporting styles
Published 11 February 2013
If you have saved your code formatting options as a style, you can share that style with other people in your organization by exporting it.
To export a style
SQL Prompt exports the style as a single file with a .sqlpromptstyle extension.
- Set all the formatting options that you want:
On the SQL Prompt Options dialog box, use the options on the various Format pages to lay out the code the way you want it. Select the Current Query tab to preview how the code currently in your SQL editor would be laid out using these settings. - On the Format > Styles page, click Export.
- Browse to where you want to store the file and click Save.
To import a style
- In the Format > Styles page, select Import from the Style drop-down list:
- Browse to the folder where the .sqlpromptstyle file is located, then click Open.
- All the format options will be updated. Your code will not be formatted until you click OK to close the SQL Prompt Options dialog box and then apply the style.