xSQL Schema Compare SDK for SQL Server version 12
AlterProcedureWithDropCreate Property


Gets or sets the value that indicates whether the stored procedures should be altered using a DROP/CREATE statement instead of the ALTER statement.
Syntax
'Declaration
 
<ComparisonOptionDescriptorAttribute(ComparisonOptionTypeEnum.ComparisonOption)>
Public Property AlterProcedureWithDropCreate As System.Boolean
[ComparisonOptionDescriptorAttribute(ComparisonOptionTypeEnum.ComparisonOption)]
public System.bool AlterProcedureWithDropCreate {get; set;}
[ComparisonOptionDescriptorAttribute(ComparisonOptionTypeEnum.ComparisonOption)]
public: __property System.bool get_AlterProcedureWithDropCreate();
public: __property void set_AlterProcedureWithDropCreate( 
   System.bool value
);
Remarks
The default value for this option is false.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

ComparisonOptions Class
ComparisonOptions Members

 

 


©Copyright 2022 xSQL Software. All Rights Reserved.

Send Feedback