.png)
Check.Text Property
SQL Server 2012
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)] public string Text { get; set; }
Property Value
Type: System.StringA 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:
