.png)
Check Properties
SQL Server 2005
(see also
Protected
Properties
)
| Name | 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
)
|
| Name | 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
)
|
