[SSDT] Provide more "Script As" options in SSOX by Jamie Thomson

Active

Type:	Suggestion
ID:	780378
Opened:	3/1/2013 5:05:13 AM
Access Restriction:	Public

Workaround(s)

view

SQL Server Object Explorer (SSOX) enables one to connect to a database, right click on a stored-procedure and select:
Script As >
Create To >
    New Query Windows
    Clipboard
    File
Alter To >
    New Query Windows
    Clipboard
    File
Drop To >
    New Query Windows
    Clipboard
    File
Drop and Create to >
    New Query Windows
    Clipboard
    File

There is an option missing tho:
Script As >
Execute To >
    New Query Windows
    Clipboard
    File

Similarly, tables should have:
Script As >
SELECT To >
    New Query Windows
    Clipboard
    File
INSERT To >
    New Query Windows
    Clipboard
    File
DELETE To >
    New Query Windows
    Clipboard
    File
UPDATE To >
    New Query Windows
    Clipboard
    File

I'm sure there are a multitude of other missing "Script As" options. Please rectify this.

Details (expand)

English

Developer Tools (SSDT, BIDS, etc.)

Simply look at what scripting options SSMS has. Copy those.

Improved User Interface

0 attachments

Posted by Microsoft on 3/4/2013 at 8:32 AM

Thanks for the feedback. We currently don't have support for the added scripting options on our schedule. We've catalogued your request.

Posted by Microsoft on 3/1/2013 at 4:47 PM

Hello Jamie. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)

Microsoft