CODEWITHSUNDEEP
sqlssmshotkeys
David Rodecker
David Rodecker

Reputation: 127

Keyboard accelerators in SQL SSMS to script a table, proc, UDF or a view's definition

In the post for "SQL Server Management Studio – tips for improving the TSQL coding process" it was referenced to use Keyboard accelerators such as Ctrl-0 to Quickly script a table's data, or a proc, UDF, or view's definition. How exactly is this done? Shouldn't it be available by customizing the context menus and assigning a hotkey to the script object to clipboard option?

Upvotes: 1

Views: 98

Answers (1)

Michael Green
Michael Green

Reputation: 1491

Look at SSMS -> Options -> Tools -> Environment / Keyboard. There's a list of key combinations and the stored procedure each will execute. You can write your own SP and add it in here.

Upvotes: 2

Related Questions