How to edit SSMS Script Table As templates?

Question

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?

@Mitch: Please post as an answer to be accepted – abatishchev Feb 05 '11 at 08:56 — abatishchev, Feb 05 '11 at 08:56

score 1 · Answer 1 · answered Jan 25 '11 at 11:24

1

What do you want to do with this?

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

answered Jan 25 '11 at 11:24

gbn

422,506
82
585
676

1

I want to "normalize" them relatively to my style and remove elements being unnecessary for me and other junk – abatishchev Jan 25 '11 at 11:35

Mitch Wheat · Accepted Answer · 2011-02-05T09:22:53.337

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)

edited Feb 05 '11 at 09:22

answered Feb 05 '11 at 09:12

Mitch Wheat

295,962
43
465
541

How to edit SSMS Script Table As templates?

2 Answers2

Linked