Check 类
The Check object represents a Microsoft SQL Server check constraint.
继承层次结构
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
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public NotInheritable Class Check _
Inherits ScriptNameObjectBase _
Implements ICreatable, IDroppable, IRenamable, IMarkForDrop, _
IAlterable, IExtendedProperties, IScriptable
用法
Dim instance As Check
public sealed class Check : ScriptNameObjectBase,
ICreatable, IDroppable, IRenamable, IMarkForDrop, IAlterable,
IExtendedProperties, IScriptable
public ref class Check sealed : public ScriptNameObjectBase,
ICreatable, IDroppable, IRenamable, IMarkForDrop, IAlterable,
IExtendedProperties, IScriptable
[<SealedAttribute>]
type Check =
class
inherit ScriptNameObjectBase
interface ICreatable
interface IDroppable
interface IRenamable
interface IMarkForDrop
interface IAlterable
interface IExtendedProperties
interface IScriptable
end
public final class Check extends ScriptNameObjectBase implements ICreatable, IDroppable, IRenamable, IMarkForDrop, IAlterable, IExtendedProperties, IScriptable
Check 类型公开以下成员。
构造函数
名称 | 说明 | |
---|---|---|
Check() () () () | Initializes a new instance of the Check class. | |
Check(SqlSmoObject, String) | Initializes a new instance of the Check class, which is owned by the specified parent object and has the specified name. |
页首
属性
名称 | 说明 | |
---|---|---|
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. | |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (从 SqlSmoObject 继承。) | |
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. | |
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (从 SqlSmoObject 继承。) | |
Name | Gets or sets the name of the object. (从 NamedSmoObject 继承。) | |
NotForReplication | Gets the Boolean property value that specifies whether the check constraint is available for replication or not. | |
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (从 SqlSmoObject 继承。) | |
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. (从 SqlSmoObject 继承。) | |
ScalarResult | Gets the scalar result for the referenced object. (从 SqlSmoObject 继承。) | |
State | Gets the state of the referenced object. (从 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. (从 SqlSmoObject 继承。) | |
UserData | Gets or sets user-defined data associated with the referenced object. (从 SmoObjectBase 继承。) |
页首
方法
页首
显式接口实现
名称 | 说明 | |
---|---|---|
IAlienObjectDiscover | (从 SqlSmoObject 继承。) | |
IAlienObjectGetParent | (从 SqlSmoObject 继承。) | |
IAlienObjectGetProperty | (从 SqlSmoObject 继承。) | |
ISfcPropertyProviderGetPropertySet | (从 SqlSmoObject 继承。) | |
IAlienObjectGetUrn | (从 SqlSmoObject 继承。) | |
IAlienObjectResolve | (从 SqlSmoObject 继承。) | |
IAlienObjectSetProperty | (从 SqlSmoObject 继承。) |
页首
注释
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
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。