This topic has not yet been rated - Rate this topic

Check Class

SQL Server 2008

The Check object represents a Microsoft SQL Server check constraint.

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

Syntax

C++

JScript

public sealed class Check : ScriptNameObjectBase, 
	ICreatable, IDroppable, IRenamable, IMarkForDrop, IAlterable, 
	IExtendedProperties, IScriptable

Remarks

To get Check object properties, users can be a member of the public fixed server role.

To set Check object properties and run the Alter method, users must have ALTER permission on the parent table or column, or be a member of the db_owner fixed database role.

To create a check constraint, users must have ALTER permission on the parent table, or be a member of the db_owner fixed database role.

To drop a check constraint, users must have ALTER permission on the parent table, or be a member of the db_owner fixed database role.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.SmoObjectBase
    Microsoft.SqlServer.Management.Smo.SqlSmoObject
      Microsoft.SqlServer.Management.Smo.NamedSmoObject
        Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
          Microsoft.SqlServer.Management.Smo.Check

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

Check Members

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Working with Database Objects

CHECK Constraints

CREATE TABLE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD