Update-CodeObjectMetadata

Updates the metadata for a stored procedure, user-defined function, view, trigger, etc.

Syntax

Update-CodeObjectMetadata [-SchemaName <String>] [-Name] <String> [<CommonParameters>]

Update-CodeObjectMetadata [-SchemaName <String>] [-Name] <String> -DatabaseDdlTrigger [<CommonParameters>]

Update-CodeObjectMetadata [-SchemaName <String>] [-Name] <String> -ServerDdlTrigger [<CommonParameters>]

Description

SQL Server has a stored procedure, sys.sp_refreshsqlmodule, which will refresh/update a the objects used by a code object (stored procedure, user-defined function, view, etc.) if that object has changed since the code object was created.

Related Commands

http://technet.microsoft.com/en-us/library/bb326754.aspx

Parameters

Name	Type	Description	Required?	Pipeline Input	Default Value
SchemaName	String	The code object's schema name. Default is `dbo`.	false	false	dbo
Name	String	The name of the code object.	true	false
DatabaseDdlTrigger	SwitchParameter	The object is a database DDL trigger.	true	false	False
ServerDdlTrigger	SwitchParameter	The object is a server DDL trigger.	true	false	False

EXAMPLE 1

Update-CodeObjectMetadata 'GetUsers'

Demonstrates how to update the GetUsers code object.

EXAMPLE 2

Update-CodeObjectMetadata -SchemaName 'example' 'GetUsers'

Demonstrates how to update a code object in a custom schema, in this case the example schema.