SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Check Properties

SQL Server 2012

The Check type exposes the following members.

  Name Description
Public property CreateDate Gets the date and time that the check constraint was created.
Public property DateLastModified Gets the date and time that the check constraint was last modified.
Public property ExtendedProperties Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property on the Check object.
Public property ID Gets the database ID value that uniquely identifies the check constraint.
Public property 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
Public property IsEnabled Gets the Boolean property value that specifies whether the check constraint is enabled.
Public property IsFileTableDefined Gets a value that specifies whether the check constraint defines a file table.
Public property 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.
Public property Name Gets or sets the name of the check constraint. (Overrides NamedSmoObject.Name.)
Public property NotForReplication Gets the Boolean property value that specifies whether the check constraint is available for replication or not.
Public property Parent Gets the SqlSmoObject object that is the parent of the Check object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Text Gets or sets the Transact-SQL statement that defines the check constraint.
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top
  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that indicates whether the object supports design mode. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Top
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.