SSMS 단축키

jevida(강성욱) 2015.03.27 17:58 Views : 7812

SSMS 단축키


ShortcutFunction　ShortcutFunction
ALT+BREAKCancel a query　CTRL+SHIFT+F2Clear all bookmarks
ALT+F1Database object information　CTRL+SHIFT+INSERTInsert a template
ALT+F4Exit　CTRL+SHIFT+LMake selection lowercase
CTRL+ASelect all　CTRL+SHIFT+MReplace template parameters
CTRL+BMove the splitter　CTRL+SHIFT+POpen
CTRL+CCopy　CTRL+SHIFT+RRemove comment
CTRL+DDisplay results in grid format　CTRL+SHIFT+S Show client statistics
CTRL+DeleteDelete through the end of the line　CTRL+SHIFT+TShow server trace
CTRL+EExecute query　CTRL+SHIFT+UMake selection uppercase
CTRL+FFind　CTRL+TDisplay results in text format
CTRL+F2Insert/remove bookmark　CTRL+UChange database
CTRL+F4Disconnect　CTRL+VPaste
CTRL+F5Parse query and check syntax　CTRL+WWindow selector
CTRL+GGo to line　CTRL+XDelete
CTRL+HReplace　CTRL+ZUndo
CTRL+IIndex Tuning Wizard　F1Help for Query Analyzer
CTRL+KDisplay/hide execution plan　F2Move to next bookmark
CTRL+LDisplay execution plan　F3Repeat last search
CTRL+NNew query window　F4Object Search
CTRL+OConnect　F5Execute a query
CTRL+PPrint　F6Switch between query and result panes
CTRL+RShow/Hide results pane　F8Show/hide Object Browser
CTRL+SSave　SHIFT+F1Transact-SQL help 
CTRL+SHIFT+0Show options　SHIFT+F2Move to previous bookmark
CTRL+SHIFT+CComment out code　SHIFT+TABDecrease indent
CTRL+SHIFT+DELClear the active Editor pane　SHIFT+F6Switch panes
CTRL+SHIFT+FSave results to file　TABIncrease indent
　　　　　
FunctionShortcut　FunctionShortcut
Cancel a queryALT+BREAK　Make selection uppercaseCTRL+SHIFT+U
Change databaseCTRL+U　Move the splitterCTRL+B
Clear all bookmarksCTRL+SHIFT+F2　Move to next bookmarkF2
Clear the active Editor paneCTRL+SHIFT+DEL　Move to previous bookmarkSHIFT+F2
Comment out codeCTRL+SHIFT+C　New query windowCTRL+N
ConnectCTRL+O　Object SearchF4
CopyCTRL+C　OpenCTRL+SHIFT+P
Database object informationALT+F1　Parse query and check syntaxCTRL+F5
Decrease indentSHIFT+TAB　PasteCTRL+V
DeleteCTRL+X　PrintCTRL+P
Delete through the end of the lineCTRL+Delete　Remove commentCTRL+SHIFT+R
DisconnectCTRL+F4　Repeat last searchF3
Display execution planCTRL+L　ReplaceCTRL+H
Display results in grid formatCTRL+D　Replace template parametersCTRL+SHIFT+M
Display results in text formatCTRL+T　SaveCTRL+S
Display/hide execution planCTRL+K　Save results to fileCTRL+SHIFT+F
Execute a queryF5　Select allCTRL+A
Execute queryCTRL+E　Show client statisticsCTRL+SHIFT+S 
ExitALT+F4　Show optionsCTRL+SHIFT+0
FindCTRL+F　Show server traceCTRL+SHIFT+T
Go to lineCTRL+G　Show/hide Object BrowserF8
Help for Query AnalyzerF1　Show/Hide results paneCTRL+R
Increase indentTAB　Switch between query and result panesF6
Index Tuning WizardCTRL+I　Switch panesSHIFT+F6
Insert a templateCTRL+SHIFT+INSERT　Transact-SQL help SHIFT+F1
Insert/remove bookmarkCTRL+F2　UndoCTRL+Z
Make selection lowercaseCTRL+SHIFT+L　Window selectorCTRL+W
　　　　　





강성욱 / jevida@naver.com
Microsoft SQL Server MVP
Blog : http://sqlmvp.kr
Facebook : http://facebook.com/sqlmvp



, , , , , I want to
cmd_document_vote_user Update Log List
No. Subject Author Date Views
Notice 2023년 1월 - SQLER의 업데이트 강좌 리스트 코난(김대우) 2023.01.02 467
1646 SQL ServerBACKUP 암호화 jevida(강성욱) 2015.03.30 8843
1645 SQL ServerErrorLog 관리 jevida(강성욱) 2015.03.30 10603
1644 SSMS 개체 탐색기를 통한 세부 정보 보기 jevida(강성욱) 2015.03.30 11650
1643 SSMS 접속했던 서버 목록 삭제 jevida(강성욱) 2015.03.30 12488
1642 SSMS 빠른 실행 아이콘 등록 하기 jevida(강성욱) 2015.03.30 8046
» SSMS 단축키 jevida(강성욱) 2015.03.27 7812
1640 SSMS UI 기능을 이용한 스크립트 생성 [1] jevida(강성욱) 2015.03.27 6904
1639 SSMS 서버 그룹 등록 및 서버 등록 jevida(강성욱) 2015.03.27 8700
1638 SSMS 여러 개체 선택하기 jevida(강성욱) 2015.03.27 5195
1637 SSMS 서버리스트 내보내기 / 가져오기 jevida(강성욱) 2015.03.27 6413
1636 SSMS 자동복구 활성 / 비활성 jevida(강성욱) 2015.03.27 4986
1635 SSMS 시스템 데이터베이스 숨기기 jevida(강성욱) 2015.03.27 4823
1634 SSMS 쿼리 자동 줄 바꿈 jevida(강성욱) 2015.03.27 9416
1633 SSMS 인텔리전스 사용 jevida(강성욱) 2015.03.27 6226
1632 SSMS 줄 번호 표시 jevida(강성욱) 2015.03.26 64510
1631 SSMS 시작 옵션 변경하기 jevida(강성욱) 2015.03.26 4329
1630 SSMS 쿼리 결과 다른 탭에 표시하기 jevida(강성욱) 2015.03.26 5033
1629 SSMS 연결 표시줄 색상 변경 jevida(강성욱) 2015.03.26 4801
1628 SSMS 결과 복사시 열 머리글 포함하기 jevida(강성욱) 2015.03.26 4752
1627 SSMS 결과물을 쉼표로 구분하여 출력하기 jevida(강성욱) 2015.03.26 4032
Write Tag


XE Login