Edition) Change the SQL beautifier options. Option / Button Description Single Line Braces Word/Symbol Limit Set the length of the short brace. Upper case keywords Format all the SQL keywords sensitive search. Regular Expression Search regular expressions. Whole Word Return the objects that match the entire word of the search string. Copy with Quotes To copy the SQL statement with quotes format. Word Wrap In the Word Wrap mode, the horizontal scrollbar is removed. SQL statement that exceeds the width of the editor window size wraps to the next line. To enable Word Wrap, choose View

Edition) Change the SQL beautifier options. Option / Button Description Single Line Braces Word/Symbol Limit Set the length of the short brace. Upper case keywords Format all the SQL keywords search. 114 Regular Expression Search regular expressions. Whole Word Return the objects that match the entire word of the search string. Copy with Quotes To copy the SQL statement with quotes format. Word Wrap In the Word Wrap mode, the horizontal scrollbar is removed. SQL statement that exceeds the width of the editor window size wraps to the next line. To enable Word Wrap, choose View

Enable case sensitive search. 113 Whole Words Return the objects that match the entire word of the search string. Copy with Quotes To copy the SQL statement with quotes, just simply control-click format. Word Wrap In the Word Wrap mode, the horizontal scrollbar is removed. SQL statement that exceeds the width of the editor window size wraps to the next line. To enable Word Wrap, choose View View -> Word Wrap. Zoom In/Zoom Out Navicat has the ability to zoom in or zoom out the SQL in the editor. The zooming options are available from the View menu. The same effect can be achieved with

insensitive. Whole word By default, the word specified in the search field can be found in the case when the word is part of another word. Enabling this setting will lead to a particular word search. Regular In the search field, you can use for Ctrl+Space autocomplete regular expressions templates. Wrap search Enable this setting to find matches throughout the object from the beginning, and not only the format '[schema name].[table name]', select the checkbox. Use the fully qualified names To wrap the SQL query into one line, select the checkbox: Compact SQL DBeaver User Guide 22.1. Page 74

insensitive. Whole word By default, the word specified in the search field can be found in the case when the word is part of another word. Enabling this setting will lead to a particular word search. Regular In the search field, you can use for Ctrl+Space autocomplete regular expressions templates. Wrap search Enable this setting to find matches throughout the object from the beginning, and not only the format '[schema name].[table name]', select the checkbox. Use the fully qualified names To wrap the SQL query into one line, select the checkbox: Compact SQL DBeaver User Guide 22.2. Page 74

insensitive. Whole word By default, the word specified in the search field can be found in the case when the word is part of another word. Enabling this setting will lead to a particular word search. Regular In the search field, you can use for Ctrl+Space autocomplete regular expressions templates. Wrap search Enable this setting to find matches throughout the object from the beginning, and not only the format '[schema name].[table name]', select the checkbox. Use the fully qualified names To wrap the SQL query into one line, select the checkbox: Compact SQL DBeaver User Guide 22.3. Page 75

insensitive. Whole word By default, the word specified in the search field can be found in the case when the word is part of another word. Enabling this setting will lead to a particular word search. Regular In the search field, you can use for Ctrl+Space autocomplete regular expressions templates. Wrap search Enable this setting to find matches throughout the object from the beginning, and not only the format '[schema name].[table name]', select the checkbox. Use the fully qualified names To wrap the SQL query into one line, select the checkbox: Compact SQL DBeaver User Guide 23.0. Page 77

insensitive. Whole word By default, the word specified in the search field can be found in the case when the word is part of another word. Enabling this setting will lead to a particular word search. Regular In the search field, you can use for Ctrl+Space autocomplete regular expressions templates. Wrap search Enable this setting to find matches throughout the object from the beginning, and not only the format '[schema name].[table name]', select the checkbox. Use the fully qualified names To wrap the SQL query into one line, select the checkbox: Compact SQL DBeaver User Guide 23.1. Page 93

command. Which tokens are valid depends on the syntax of the particular command. A token can be a key word, an identifier, a quoted identifier, a literal (or constant), or a special character symbol. Tokens the same lexical structure, meaning that one cannot know whether a token is an identifier or a key word without knowing the language. A complete list of key words can be found in Appendix C. SQL identifiers diacritical marks and non-Latin letters) or an underscore (_). Subsequent characters in an identifier or key word can be letters, underscores, digits (0-9), or dollar signs ($). Note that dollar signs are not allowed

command. Which tokens are valid depends on the syntax of the particular command. A token can be a key word, an identifier, a quoted identifier, a literal (or constant), or a special character symbol. Tokens the same lexical structure, meaning that one cannot know whether a token is an identifier or a key word without knowing the language. A complete list of key words can be found in Appendix C. SQL identifiers diacritical marks and non-Latin letters) or an underscore (_). Subsequent characters in an identifier or key word can be letters, underscores, digits (0-9), or dollar signs ($). Note that dollar signs are not allowed