SoftadminGuide.SqlObject_CreateOrAlter

Type: Stored procedure

Creates or alters a stored procedure with the given definition, logs it in the guide history and makes it possible to revert if the procedure was created and not altered.

Parameters

@FullObjectName mandatory nvarchar(600)

The full object name of the SQL module to create or alter.

@Definition mandatory nvarchar(max)

The SQL module definition.

@IsMainObject optional bit

A value indicating whether the object should be the main object when multiple object are created, the main object is displayed in the log overview. If there is no main object the first created object is displayed in the overview. Default 0.