Modify "Script Table as" template

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aas4mis
    New Member
    • Jan 2008
    • 97

    Modify "Script Table as" template

    Does anybody know if it's possible to modify the "Script Table as" template within SSMS (2008)? If not, is it possible to add another template so that when I right click an object (table) in the object explorer I'm able to use my own template?

    Not looking at the Template Explorer, just looking at the right click function in Object Explorer.

    This is more of a pet peave than anything, I'd like to use my own coding style by default. Such as setting the comma at the end of the line, rather than the start of a new line.

    Thanks
    --aas4mis
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    If you just want this so you can export a script to create a table, you can create an SP that reads the information schema view to dynamically create an sql statement to create a table.

    Good Luck!!!


    ~~ CK

    Comment

    Working...