Default 类
The Default object represents a SQL Server default.
继承层次结构
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.ScriptSchemaObjectBase
Microsoft.SqlServer.Management.Smo.DefaultRuleBase
Microsoft.SqlServer.Management.Smo.Default
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class Default _
Inherits DefaultRuleBase _
Implements ISfcSupportsDesignMode
用法
Dim instance As Default
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
public sealed class Default : DefaultRuleBase,
ISfcSupportsDesignMode
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
public ref class Default sealed : public DefaultRuleBase,
ISfcSupportsDesignMode
[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
type Default =
class
inherit DefaultRuleBase
interface ISfcSupportsDesignMode
end
public final class Default extends DefaultRuleBase implements ISfcSupportsDesignMode
Default 类型公开以下成员。
构造函数
名称 | 说明 | |
---|---|---|
Default() | Initializes a new instance of the Default class. | |
Default(Database, String) | Initializes a new instance of the Default class on the specified database and with the specified name. | |
Default(Database, String, String) | Initializes a new instance of the Default class on the specified database and with the specified name and schema. |
页首
属性
名称 | 说明 | |
---|---|---|
CreateDate | Gets the date and time when the default was created. | |
ExtendedProperties | Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property on the Default object or the Rule object. (从 DefaultRuleBase 继承。) | |
ID | Gets the ID value that uniquely identifies the default. | |
Name | Gets or sets the name of the schema. (从 ScriptSchemaObjectBase 继承。) | |
Parent | Gets or sets the Database object that is the parent of the Default object. | |
Properties | Gets a collection of Property objects that represent the object properties. (从 SqlSmoObject 继承。) | |
Schema | Gets or sets the schema. (从 ScriptSchemaObjectBase 继承。) | |
State | Gets the state of the referenced object. (从 SmoObjectBase 继承。) | |
TextBody | Gets or sets the text that defines the default or rule. (从 DefaultRuleBase 继承。) | |
TextHeader | Gets or sets the header of the text body that defines the default or rule. (从 DefaultRuleBase 继承。) | |
TextMode | Gets or sets the Boolean property value that specifies whether the Default object or Rule object header is editable as text. (从 DefaultRuleBase 继承。) | |
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 继承。) |
页首
方法
名称 | 说明 | |
---|---|---|
Alter | Updates any Default object or Rule object property changes on instance of SQL Server. (从 DefaultRuleBase 继承。) | |
BindToColumn(String, String) | Binds the default or rule to the specified column in the specified table. (从 DefaultRuleBase 继承。) | |
BindToColumn(String, String, String) | Binds the default or rule to the specified column in the specified table with the specified schema. (从 DefaultRuleBase 继承。) | |
BindToDataType | Binds the default or rule to a data type. (从 DefaultRuleBase 继承。) | |
ChangeSchema | Changes the schema for the default. | |
Create | Creates a default or rule on the instance of SQL Server as defined by the Default object or Rule object. (从 DefaultRuleBase 继承。) | |
Discover | Discovers a list of type Object. (从 SqlSmoObject 继承。) | |
Drop | Removes the rule or the default. (从 DefaultRuleBase 继承。) | |
EnumBoundColumns | Enumerates a list of columns to which the default or rule is bound. (从 DefaultRuleBase 继承。) | |
EnumBoundDataTypes | Enumerates a list of data types to which the default or rule is bound. (从 DefaultRuleBase 继承。) | |
Equals | (从 Object 继承。) | |
FormatSqlVariant | Formats an object as SqlVariant type. (从 SqlSmoObject 继承。) | |
GetContextDB | Gets the context database that is associated with this object. (从 SqlSmoObject 继承。) | |
GetDBName | Gets the database name that is associated with the object. (从 SqlSmoObject 继承。) | |
GetHashCode | (从 Object 继承。) | |
GetPropValue | Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。) | |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。) | |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。) | |
GetServerObject | Gets the server of the SqlSmoObject object. (从 SqlSmoObject 继承。) | |
GetType | (从 Object 继承。) | |
Initialize() | Initializes the object and forces the properties be loaded. (从 SqlSmoObject 继承。) | |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (从 SqlSmoObject 继承。) | |
IsObjectInitialized | Verifies whether the object has been initialized. (从 SqlSmoObject 继承。) | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (从 SqlSmoObject 继承。) | |
Refresh | Refreshes the script name. (从 ScriptNameObjectBase 继承。) | |
Script() | Generates a Transact-SQL script that can be used to re-create the default or rule. (从 DefaultRuleBase 继承。) | |
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the default or rule as specified by the script options. (从 DefaultRuleBase 继承。) | |
ScriptHeader | Generates a Transact-SQL script that can be used to re-create the default or rule header as specified by the script options. (从 DefaultRuleBase 继承。) | |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (从 SqlSmoObject 继承。) | |
ToString | Returns a String that represents the referenced object. (从 SqlSmoObject 继承。) | |
UnbindFromColumn(String, String) | Unbinds the default or rule from the specified column. (从 DefaultRuleBase 继承。) | |
UnbindFromColumn(String, String, String) | Unbinds the default or rule from the specified column with the specified table schema. (从 DefaultRuleBase 继承。) | |
UnbindFromDataType | Unbinds the default or rule from the specified data type (从 DefaultRuleBase 继承。) | |
Validate | Validates the state of an object. (从 SmoObjectBase 继承。) |
页首
事件
名称 | 说明 | |
---|---|---|
PropertyChanged | Represents the event that occurs when a property is changed. (从 SqlSmoObject 继承。) | |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (从 SqlSmoObject 继承。) |
页首
显式接口实现
名称 | 说明 | |
---|---|---|
IAlienObject.Discover | Discovers any dependencies. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject.GetDomainRoot | Returns the root of the domain. (从 SqlSmoObject 继承。) | |
IAlienObject.GetParent | Gets the parent of this object. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject.GetPropertyType | Gets the type of the specified property. (从 SqlSmoObject 继承。) | |
IAlienObject.GetPropertyValue | Gets the value of the specified property. (从 SqlSmoObject 继承。) | |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (从 SqlSmoObject 继承。) | |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (从 SqlSmoObject 继承。) | |
IAlienObject.SetPropertyValue | Sets the property value. (从 SqlSmoObject 继承。) | |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (从 SqlSmoObject 继承。) | |
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that indicates whether the object supports design mode. 标识为仅供参考。不提供支持。不保证以后的兼容性。 |
页首
注释
To get Default object properties, users can be a member of the public fixed server role.
To set Default object properties, users must have CREATE DEFAULT permission on the database.
To create a default, users must have CREATE DEFAULT permission on the database.
To drop a default, users must have DROP DEFAULT permission on the database.
To bind a default to a column or unbind a default from a column, users must be a member of db_owner or db_ddladmin fixed database roles.
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。
示例
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。
请参阅
参考
Microsoft.SqlServer.Management.Smo 命名空间