Check Members

The Check object represents a Microsoft SQL Server check constraint.

The following tables list the members exposed by the Check type.

Public Constructors

	Nombre	Description
	Check	Overloaded. Initializes a new instance of the Check class.

Arriba

Protected Fields

	Nombre	Description
	m_ExtendedProperties	(inherited from SqlSmoObject )

Arriba

Public Properties

(see also Protected Properties )

	Nombre	Description
	CreateDate	Gets the date and time that the check constraint was created.
	DateLastModified	Gets the date and time that the check constraint was last modified.
	ExtendedProperties	Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property on the Check object.
	ID	Gets the database ID value that uniquely identifies the check constraint.
	IsChecked	Gets the Boolean property value that specifies whether the constraint was enabled without checking existing rows, so constraint may not hold for all rows
	IsEnabled	Gets the Boolean property value that specifies whether the check constraint is enabled.
	IsSystemNamed	Gets the Boolean property value that specifies whether the check constraint was named automatically by Microsoft SQL Server or named by the database object creator.
	Name	Gets or sets the name of the object. (inherited from NamedSmoObject)
	NotForReplication	Gets the Boolean property value that specifies whether the check constraint is available for replication or not.
	Parent	Gets the SqlSmoObject object that is the parent of the Check object.
	Properties	Gets a collection of Property objects that represent the object properties. (inherited from SqlSmoObject)
	State	Gets the state of the referenced object. (inherited from SmoObjectBase)
	Text	Gets or sets the Transact-SQL statement that defines the check constraint.
	Urn	Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (inherited from SqlSmoObject)
	UserData	Gets or sets user-defined data associated with the referenced object. (inherited from SmoObjectBase)

Arriba

Protected Properties

	Nombre	Description
	ExecuteForScalar	Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject)
	ObjectInSpace	Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly. (inherited from SqlSmoObject)
	PresetProperties	Gets or sets the preset properties of the referenced object. (inherited from SqlSmoObject)
	ScalarResult	Gets the scalar result for the referenced object. (inherited from SqlSmoObject)

Arriba

Public Methods

(see also Protected Methods )

	Nombre	Description
	Alter	Updates any Check object property changes on an instance of Microsoft SQL Server.
	Create	Creates a check constraint on the instance of Microsoft SQL Server as defined by the Check object.
	Drop	Drops the check constraint.
	Equals	Overloaded. (inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	Initialize	Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject)
	MarkForDrop	Marks the foreign key to be dropped next time its parent Table object is altered by the Alter method.
	ReferenceEquals	(inherited from Object )
	Refresh	Refreshes the script name. (inherited from ScriptNameObjectBase)
	Rename	Marks the foreign key to be dropped next time its parent Table object is altered by the Alter method.
	Script	Overloaded. Generates a Transact-SQL script that can be used to re-create the check constraint.
	ToString	Returns a String that represents the referenced object. (inherited from SqlSmoObject)

Arriba

Protected Methods

	Nombre	Description
	AlterImpl	(inherited from SqlSmoObject )
	AlterImplFinish	(inherited from SqlSmoObject )
	AlterImplInit	(inherited from SqlSmoObject )
	AlterImplWorker	(inherited from SqlSmoObject )
	AppendCommaText	(inherited from ScriptNameObjectBase )
	AppendWithCommaText	(inherited from ScriptNameObjectBase )
	AppendWithOption	(inherited from ScriptNameObjectBase )
	BindDefaultImpl	(inherited from SqlSmoObject )
	BindRuleImpl	(inherited from SqlSmoObject )
	CheckCollation	(inherited from SqlSmoObject )
	CheckObjectState	Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject)
	CheckObjectStateImpl	(inherited from SqlSmoObject )
	CheckTextCorectness	(inherited from ScriptNameObjectBase )
	CheckTextModeSupport	(inherited from ScriptNameObjectBase )
	CheckVersion80	Checks the validity of the object on Microsoft SQL Server 2000. (inherited from SqlSmoObject)
	CheckVersion80SP3	Checks the validity of the object on Microsoft SQL Server 2000 SP3. (inherited from SqlSmoObject)
	CheckVersion90	Check the validity of the object on Microsoft SQL Server 2005. (inherited from SqlSmoObject)
	CheckVersionBelow90	(inherited from SqlSmoObject )
	CleanObject	Cleans the referenced object. (inherited from ScriptNameObjectBase)
	CreateImpl	(inherited from SqlSmoObject )
	CreateImplFinish	(inherited from SqlSmoObject )
	CreateImplInit	(inherited from SqlSmoObject )
	DropImpl	(inherited from SqlSmoObject )
	DropImplWorker	(inherited from SqlSmoObject )
	Finalize	(inherited from Object )
	ForceTextModeOnTextBody	Enforces text mode on the text body. (inherited from ScriptNameObjectBase)
	FormatSqlVariant	(inherited from SqlSmoObject )
	GenerateDataSpaceScript	(inherited from SqlSmoObject )
	GetBindDefaultScript	(inherited from SqlSmoObject )
	GetBindRuleScript	(inherited from SqlSmoObject )
	GetBoolParameter	Overloaded. (inherited from SqlSmoObject )
	GetBraketNameForText	(inherited from ScriptNameObjectBase )
	GetDateTimeParameter	(inherited from SqlSmoObject )
	GetDateTimeParameterAsInt	(inherited from SqlSmoObject )
	GetDBName	Gets the database name associated with the object. (inherited from SqlSmoObject)
	GetEnumParameter	(inherited from SqlSmoObject )
	GetFragOptionString	(inherited from SqlSmoObject )
	GetGuidParameter	(inherited from SqlSmoObject )
	GetIsTextDirty	Determines whether the text value is consistent with stored value. (inherited from ScriptNameObjectBase)
	GetParameter	Overloaded. (inherited from SqlSmoObject )
	GetPropValue	(inherited from SqlSmoObject )
	GetPropValueOptional	(inherited from SqlSmoObject )
	GetPropValueOptionalAllowNull	(inherited from SqlSmoObject )
	GetRealValue	(inherited from SqlSmoObject )
	GetScriptIncludeExists	(inherited from ScriptNameObjectBase )
	GetScriptingOptionsForCreate	(inherited from SqlSmoObject )
	GetServerName	Gets the name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
	GetSqlServerVersionName	Gets the version name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
	GetStringParameter	Overloaded. (inherited from SqlSmoObject )
	GetTextBody	Overloaded. Returns the text body. (inherited from ScriptNameObjectBase)
	GetTextForScript	(inherited from ScriptNameObjectBase )
	GetTextHeader	(inherited from ScriptNameObjectBase )
	GetTextMode	Determines whether the script name is using text mode. (inherited from ScriptNameObjectBase)
	GetTextProperty	(inherited from ScriptNameObjectBase )
	GetTimeSpanParameterAsInt	(inherited from SqlSmoObject )
	GetUrnRecursive	Overloaded. (inherited from SqlSmoObject )
	ImplInitialize	(inherited from SqlSmoObject )
	IsCollectionDirty	(inherited from SqlSmoObject )
	IsObjectDirty	Determines whether the referenced object is consistent with the stored object. (inherited from ScriptNameObjectBase)
	IsObjectInitialized	Verifies whether the object has been initialized. (inherited from SqlSmoObject)
	IsObjectInSpace	Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server. (inherited from SqlSmoObject)
	IsVersion80SP3	(inherited from SqlSmoObject )
	MarkDropped	(inherited from SqlSmoObject )
	MarkForDropImpl	(inherited from SqlSmoObject )
	MemberwiseClone	(inherited from Object )
	PostAlter	(inherited from SqlSmoObject )
	PostCreate	(inherited from SqlSmoObject )
	PostDrop	(inherited from SqlSmoObject )
	RenameImpl	(inherited from NamedSmoObject )
	RenameImplWorker	(inherited from NamedSmoObject )
	ScriptAlter	(inherited from SqlSmoObject )
	ScriptAnsiQI	(inherited from ScriptNameObjectBase )
	ScriptChangeOwner	(inherited from NamedSmoObject )
	ScriptCreate	(inherited from SqlSmoObject )
	ScriptDdl	(inherited from SqlSmoObject )
	ScriptDrop	(inherited from SqlSmoObject )
	ScriptImpl	Overloaded. (inherited from SqlSmoObject )
	ScriptImplWorker	(inherited from SqlSmoObject )
	ScriptInformativeHeaders	(inherited from ScriptNameObjectBase )
	ScriptRename	(inherited from NamedSmoObject )
	SetCollectionTextMode	(inherited from ScriptNameObjectBase )
	SetParentImpl	(inherited from SqlSmoObject )
	SetTextBody	(inherited from ScriptNameObjectBase )
	SetTextHeader	(inherited from ScriptNameObjectBase )
	SetTextMode	(inherited from ScriptNameObjectBase )
	SwitchTextMode	(inherited from ScriptNameObjectBase )
	ThrowIfTextIsDirtyForAlter	(inherited from ScriptNameObjectBase )
	Trace	(inherited from SqlSmoObject )
	UnbindDefaultImpl	(inherited from SqlSmoObject )
	UnbindRuleImpl	(inherited from SqlSmoObject )
	UpdateCollectionState2	(inherited from SqlSmoObject )

Arriba

Vea también

Referencia

Check Class
Microsoft.SqlServer.Management.Smo Namespace

Otros recursos

Working with Database Objects
Restricciones CHECK
CREATE TABLE (Transact-SQL)