Changing the SQL statement terminator

By default, the SQL editor uses a semicolon ( ; ) as the default statement terminator. You can specify a different statement terminator for an SQL statement that you create in the SQL editor.

A statement terminator is specific to the SQL statement in which you specify it. You can specify different statement terminators in different SQL statements. The statement terminator can be a string of one or more case-sensitive characters.

The statement terminator that you specify for an SQL statement persists every time that you open the statement in the SQL editor.

Prerequisite: The SQL statement for which you want to change the statement terminator must be open in the SQL editor.

To change the statement terminator for an SQL statement:

  1. Right-click in the SQL editor, and then click Set Statement Terminator on the pop-up menu.
  2. In the Set Statement Terminator window, type one or more characters to use as the statement terminator and then click OK.
If you specify a statement terminator other than the default, a comment is added to the top of the SQL statement that indicates the statement terminator that you specified. Existing occurrences of the default statement terminator are not updated in the SQL statement; you must change them manually.
Related tasks
Creating SQL statements in the SQL editor by using the File menu
Creating SQL statements in the SQL editor by using a data project
Creating SQL statements in the SQL editor by using a physical data model
Creating SQL statements in the SQL editor by using a database connection
Creating SQL statements in the SQL editor by using the Database Explorer toolbar

Feedback