Contents 

AdeptSQL Diff Reference
AdeptSQl Diff versions, history and milestones
Supported versions of MS SQL Server
Getting started
Connecting to databases
Scanning available servers
Saving and opening comparisons
Running from command line
Diff in portable mode
Working with the schema
Viewing schema differences
Ignored Differences
Comparing objects side-by-side
Dragging and dropping schema items
Using schema filters
Generating comparison reports
Customizing the reports
Executing the SQL
SQL errors and warnings
Transaction support
Keyboard shortcuts
Editing commands and keyboard shortcuts
Using keyboard templates
Choosing debugger's key mapping
Comparing table data
DataDiff overview
DataDiff configuration dialog - table-level
DataDiff configuration dialog - columns
Special situations comparing data
Exporting data to Excel
DataDiff Reports
Column configuration file
Configuring AdeptSQL Diff
Options dialog
Schema Scan
Selective Loading
Comparison
Name Comparison
Code Comparison
User-defined types
Indexes and Statistics
Permissions and XProps
Synonyms
Other details to ignore
Scripting
General logic
Side-by-side scripting
Formatting
Identifiers
Schema Level
Tables
Constraints
Default Values
Procedures, Views, etc
Visuals
Text Fonts
Schema Tree
Summary collections
Side-by-Side View
Suppressed dialogs
Data comparison options
General
Scripting
Column Config File
Using COM Automation interface
Automating schema comparison
Automating data comparison
Licensing and contact info
Registration of AdeptSQL Diff
License conditions
Contact information

AdeptSQL Diff Online Help

Prev Page Next Page

Editing commands and keyboard shortcuts

Top  Previous  Next

The script editor used in AdeptSQL Diff (in the Code View popup window) supports the following keyboard combinations, most of them are also available as buttons on the Code View's toolbar:

Btn

Shortcut

Menu

Description

SQL Templates

 

...CTRL-J

 

Type one of the SQL template abbreviations, then press Ctrl-J to expand it into the whole SQL statement.

Clipboard functions

btn_copy

CTRL+C

"Edit/Copy"

Copy selected text to clipboard

btn_cut

CTRL+X

"Edit/Cut"

Cut selected text to clipboard

btn_paste

CTRL+V

"Edit/Paste"

Replace selected text with clipboard contents

Bookmark functions (<n> is a numeric key 0 .. 9)

 

CTRL+K+n

 

Sets bookmark number <n>

 

CTRL+Q+n

 

Jump to bookmark number <n>

Undo functions

btn_undo

CTRL+Z

"Edit/Undo"

Undo the last editing action

btn_redo

CTRL+SHIFT+Z

"Edit/Redo"

Redo one editing action

SQL formatting functions

btn_Indent

CTRL+K+I

 

Indents selected text by one tab step

btn_Unindent

CTRL+K+U

 

Un-indents selected text by one tab step

btn_comment

 

"Comment out"

Comment out the selected text. The program uses "/*...*/" comments for this.

btn_UnComment

 

"Uncomment"

Enabled only when you are inside a commented-out text. The program understands and correctly opens both "/*...*/" and "-- till the end of line" ones.

btn_ulcase

 

"Uppercase/Lowercase..."

Adjust case in all identifiers and keywords within the selected text. The commands pops up a dialog where you can separately select what to do with the keywords and with other identifiers.

You can view or change the default keyboard mapping in the editor configuration dialog. This dialog can be invoked from editor's context menu or from "Tools/Editor Options..." command in the main menu.

   
Converted from CHM to HTML with chm2web Standard 2.85 (unicode)