You cannot change the object type in a script.
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

You cannot change the object type in a script.

When you begin a new script, your initial shortcut menu selection determines what type of script Visual Database Tools will create. While using the SQL Editor, you cannot modify the object type. For example, if you select New Inline Function and change the script to a trigger or view, this error message appears when you attempt to save the script.

  1. Restore the current script to the original object type.

-or-

  1. Close the current script and use another menu selection to create a different type of object.
Show:
© 2016 Microsoft