GenerateCheckExistenceStatement Property

Gets or sets the value that indicates whether a check for existence should be performed before dropping an object.

Syntax

Visual Basic
C#
Managed Extensions for C++

'Declaration
 
<ComparisonOptionDescriptorAttribute(ComparisonOptionTypeEnum.ScriptingOption)>
Public Property GenerateCheckExistenceStatement As System.Boolean

[ComparisonOptionDescriptorAttribute(ComparisonOptionTypeEnum.ScriptingOption)]
public System.bool GenerateCheckExistenceStatement {get; set;}

[ComparisonOptionDescriptorAttribute(ComparisonOptionTypeEnum.ScriptingOption)]
public: __property System.bool get_GenerateCheckExistenceStatement();
public: __property void set_GenerateCheckExistenceStatement( 
   System.bool value
);

Remarks

This option add a "if exists () " statement to the script fragment that drops an object. It is supported only for the following database entities:

primary keys
unique constraints
indexes
check constraints
default constraints
foreign keys

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

Reference

ComparisonOptions Class
ComparisonOptions Members