Shortcuts

Project Shortcuts

 
Shortcut Description Menu item

Ctrl+N

Create new project

File | New Project

Ctrl+O

Open project

File | Open Project

Ctrl+E

Edit project

File | Edit Project

Ctrl+S

Save project

File | Save Project

Ctrl+Shift+S

Save project as

File | Save Project As

Alt+F4

Exit

File | Exit

F8

Options

Tools | Options

Run Shortcuts

Shortcut Description Menu item

F5

Refreshes contents of main grid

Run | Refresh

F6

Create script to drop objects

Run | Drops Generation Wizard

ApexSQL Editor Shortcuts

Shortcut Description Menu item
Ctrl+S

Save file as

File | Save file as

Ctrl+P

Print

File | Print

Ctrl+Z

Un-do

Edit | Un-do

Ctrl+Shift+Z

Re-do

Edit | Re-do

F2

Copy all

Edit | Copy all

Ctrl+X

Cut

Edit | Cut

Ctrl+C

Copy

Edit | Copy

Ctrl+V

Paste

Edit | Paste

Ctrl+A

Select all

Edit | Select all

Ctrl+F

Find

Edit | Find

F3

Find next

Edit | Find next

Ctrl+H

Replace

Edit | Replace

Ctrl+G

Goto

Edit | Goto

Ctrl+F5

Check syntax

SQL | Check syntax

F1

Managing script help

Help | Managing script help

Help Shortcuts

Shortcut Description Menu item
Ctrl+F1

Apex SQL Clean Help File

Help | Apex SQL Clean Help Contents

 
 

Project Wizard Hotkeys

Hotkey Description
Alt+H Help
Alt+R Reset
Alt+S Save
Alt+A Save as
Alt+B Back
Alt+N Next
Alt+L Analyze
Alt+C Cancel

 

 

Project

 

Hotkey Description

Alt+N

New Project

Alt+U

Use Application Defaults

Alt+L

Use Last Saved Project Settings

Alt+E

Use Existing Project as Template

Alt+P

Open Existing Project

Alt+H

Help

Alt+O

OK

Alt+C

Cancel

 

 

Login
Hotkey Description
Alt+W Windows authentication
Alt+Q SQL server authentication
Alt+E Store encrypted password

 

 

Comments
Hotkey Description
Alt+D Add new
Alt+E Delete
Alt+M Multiline comment
Alt+E Comment delimiter
Alt+E Open delimiter
Alt+L Close delimiter
Alt+O Ok

 

 

Search settings
Hotkey Description
Alt+E Search for SQL objects in case sensitive
Alt+I Ignore trigger reference to parent table
Alt+M Match whole word only

 

 

Object filter
Hotkey Description
Alt+Y Datatypes
Alt+D Defaults / DDL triggers
Alt+F Functions
Alt+P Procedures
Alt+R Rules / Remote service bindings
Alt+T Tables
Alt+G Triggers
Alt+V Views
Alt+A Assemblies
Alt+C Contracts
Alt+M Message types
Alt+O Partition Schemes / Routes
Alt+Q Queues
Alt+S Synonyms
Alt+X Xml schema collections
Alt+K Check all
Alt+U Un-check all / Fulltext catalogs
Alt+I Import selection profile / Partition functions
Alt+E Export selection profile / Event notifications / Services

 

 

File selection
Hotkey Description
Alt+U Recursive
Alt+F Filter
Alt+E Edit
Alt+D Delete

Drops Generation Wizard Hotkeys

Hotkey Description
Alt+G

Generate

 

 

General options
Hotkey Description
Alt+I

Include transaction handling in drop script

Alt+O

Don't create

Alt+U

Use default backup directory

Alt+E

Use this directory

 

 

Optional script elements
Hotkey Description
Alt+I

Script header

Alt+O

Comments

Alt+P

Print statements

 

 

Output options
Hotkey Description
Alt+D

Display script in internal editor

Alt+W

Write script to file only

Alt+E

Execute directly against database

Alt+M

Automatically re-analyze objects after script execution

Alt+T

Save To

Options Hotkeys

Hotkey Description
Alt+K

Ok

Alt+C

Cancel

Alt+Y

Apply

Alt+R

Reset

Alt+D

Default

Alt+H

Help

 

 

General options
Hotkey Description
Alt+O

Show system database

Alt+I

Highlight references in ApexSQL Editor

Alt+S

Show blank cell instead of '0' for no references

 

 

Prompt to save changes event
Hotkey Description
Alt+W

Wizard close/cancel

Alt+A

Application close

Alt+N

New/open project

 

 

Editors
Hotkey Description
Alt+A

ApexSQL Editor

Alt+M

MSSQL Query Analyzer

Alt+S

SQL Server Management Studio

Alt+O

Other