Export (0) Print
Expand All

Check.Text Property

Gets or sets the Transact-SQL statement that defines the check constraint.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Matrix)]
public string Text { get; set; }

Property Value

Type: String
A String value that specifies the actual text of the Transact-SQL statement that defines the check constraint. By default, the value is unspecified.

The Text property of the Check object is equivalent to the Transact-SQL check clause in the definition of CHECK Constraints, which specifies the actual text of the Transact-SQL definition statement.

In Transact-SQL the check constraint is defined by the statement such as:

ALTER TABLE CheckTbl

ADD CONSTRAINT chkRowCount CHECK (CheckFnctn() > 1 )

GO

In SMO, the Text property requires only the check clause:

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft