CheckExistence Property

Indicates whether a check for existence should be added to the script that drops an object. This option generates a "IF EXISTS ()..." statement.

Syntax

Visual Basic
C#
Managed Extensions for C++

'Declaration
 
Public Property CheckExistence As System.Boolean

public System.bool CheckExistence {get; set;}

public: __property System.bool get_CheckExistence();
public: __property void set_CheckExistence( 
   System.bool value
);

Remarks

This option is supported only for the following objects:

primary key
unique constraint
index
check constraint
default constraint
foreign key

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

ScriptingOptions Class
ScriptingOptions Members