How to edit SSMS Script Table As templates?

问题:

In the context menu of a table in SQL Server Management Studio there are several items under the common item Script Table as:

SELECT to
INSERT to
UPDATE to
DELETE to
..

and the same for all objects, e.g. stored procedures, functions, etc.

How can I edit the templates used by that menus?

回答1:

You cannot edit the templates used by SQL Server Management Studio (which would be a nice feature).

You can create your own (parameterised templates) in C:\Users\Username\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql (for SQL Server 2008)

回答2:

What do you want to do with this?

Have you seen the SSMS tools pack which adds some right click options?