ALTER VIEW Statement (Data Definition) Alters the definition, restrictions, or options on a view.
Alters a procedure or manually triggers a recompilation of a procedure by generating an updated execution plan. The input and output parameters of a procedure can have any of the primitive SQL types ...