DdlTriggerBase-Klasse
The DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object. This represents a SQL Server database data definition language (DDL) trigger.
Vererbungshierarchie
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.DdlTriggerBase
Microsoft.SqlServer.Management.Smo.DatabaseDdlTrigger
Microsoft.SqlServer.Management.Smo.ServerDdlTrigger
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public MustInherit Class DdlTriggerBase _
Inherits ScriptNameObjectBase _
Implements ICreatable, IAlterable, IDroppable, IScriptable, _
ITextObject
'Usage
Dim instance As DdlTriggerBase
public abstract class DdlTriggerBase : ScriptNameObjectBase,
ICreatable, IAlterable, IDroppable, IScriptable, ITextObject
public ref class DdlTriggerBase abstract : public ScriptNameObjectBase,
ICreatable, IAlterable, IDroppable, IScriptable, ITextObject
[<AbstractClassAttribute>]
type DdlTriggerBase =
class
inherit ScriptNameObjectBase
interface ICreatable
interface IAlterable
interface IDroppable
interface IScriptable
interface ITextObject
end
public abstract class DdlTriggerBase extends ScriptNameObjectBase implements ICreatable, IAlterable, IDroppable, IScriptable, ITextObject
Der DdlTriggerBase-Typ macht folgende Elemente verfügbar.
Konstruktoren
| Name | Beschreibung | |
|---|---|---|
.gif "Geschützte Methode") |
DdlTriggerBase | Initializes a new instance of the DatabaseDdlTrigger class. |
Zum Anfang
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
.gif "Geschützte Eigenschaft") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Geerbt von SqlSmoObject.) |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Geerbt von SqlSmoObject.) |
.gif "Öffentliche Eigenschaft") |
Name | Gets or sets the name of the object. (Geerbt von NamedSmoObject.) |
|
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. (Geerbt von SqlSmoObject.) |
|
Properties | Gets a collection of Property objects that represent the object properties. (Geerbt von SqlSmoObject.) |
|
ScalarResult | Gets the scalar result for the referenced object. (Geerbt von SqlSmoObject.) |
|
State | Gets the state of the referenced object. (Geerbt von SmoObjectBase.) |
|
TextBody | Gets or sets the body text that is used in the definition of the database data definition language (DDL) trigger. |
|
TextHeader | Gets or sets the header text that is used in the definition of the database data definition language (DDL) trigger. |
|
TextMode | Gets or sets the Boolean property value that specifies whether the DatabaseDdlTrigger header is editable as text. |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Geerbt von SqlSmoObject.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (Geerbt von SmoObjectBase.) |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
|
AddDatabaseContext | Add the database context to the collection of queries identified by the queries parameter. (Geerbt von SqlSmoObject.) |
.gif "Öffentliche Methode") |
Alter | Updates any DatabaseDdlTrigger object property changes on the instance of SQL Server. |
|
AlterImpl | Activates the object altered event. (Geerbt von SqlSmoObject.) |
|
AlterImplWorker | Calls the Alter methods. (Geerbt von SqlSmoObject.) |
|
AppendCommaText | Appends text, optionally separated by a comma. (Geerbt von ScriptNameObjectBase.) |
|
AppendWithCommaText | Appends text, optionally separated by a comma. (Geerbt von ScriptNameObjectBase.) |
|
AppendWithOption | Appends text and option text separated from the main text with a “WITH” string and optionally separated by a comma. (Geerbt von ScriptNameObjectBase.) |
|
AutoGenerateName | Generates a name based on the object Guid. (Geerbt von ScriptNameObjectBase.) |
|
BindDefaultImpl | Binds the default items identified by the parameters. (Geerbt von SqlSmoObject.) |
|
BindRuleImpl | Binds the rule schema to the rule and columns identified by the parameters. (Geerbt von SqlSmoObject.) |
|
CheckObjectDirty | Determines whether the object has been updated since the last call to the Alter method. (Überschreibt ScriptNameObjectBase.CheckObjectDirty().) |
|
CheckObjectState() | Validates the state of the referenced object. (Geerbt von SqlSmoObject.) |
|
CheckObjectState(Boolean) | Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Geerbt von SqlSmoObject.) |
|
CheckObjectStateImpl | Checks the state of a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
CheckTextCorectness | Checks text for correctness against the parameters. (Geerbt von ScriptNameObjectBase.) |
|
CheckTextModeSupport | Checks mode of support. (Geerbt von ScriptNameObjectBase.) |
|
CheckVersion100 | Checks whether version of SQL Server is SQL Server 2008. (Geerbt von SqlSmoObject.) |
|
CheckVersion110() | Checks whether version of SQL Server is SQL Server 2012. (Geerbt von SqlSmoObject.) |
|
CheckVersion110(String) | Checks whether the version of SQL Server is SQL Server 2012 with the specified name. (Geerbt von SqlSmoObject.) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Geerbt von SqlSmoObject.) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Geerbt von SqlSmoObject.) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Geerbt von SqlSmoObject.) |
|
CheckVersionBelow110 | Checks whether version of SQL Server is before SQL Server 2012. (Geerbt von SqlSmoObject.) |
|
CheckVersionBelow90 | Checks whether version of SQL Server is before SQL Server 2005. (Geerbt von SqlSmoObject.) |
|
CleanObject | Cleans the referenced object. (Geerbt von ScriptNameObjectBase.) |
|
Create | Creates a database data definition language (DDL) trigger on the instance of SQL Server as defined by the DatabaseDdlTrigger object. |
|
CreateImpl | Creates an object with scripting options. (Geerbt von SqlSmoObject.) |
|
Discover | Discovers a list of type Object. (Geerbt von SqlSmoObject.) |
|
Drop | Drops the database data definition language (DDL) trigger. |
|
DropImpl | Drops a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
DropImplWorker | Calls the drop methods. (Geerbt von SqlSmoObject.) |
|
Equals | (Geerbt von Object.) |
|
ExecuteNonQuery | Executes a batch of statements that does not return a result set. (Geerbt von SqlSmoObject.) |
|
ExecuteRenameQuery | Executes the rename query for the object. (Geerbt von NamedSmoObject.) |
|
Finalize | (Geerbt von Object.) |
|
ForceTextModeOnTextBody | Enforces text mode on the text body. (Geerbt von ScriptNameObjectBase.) |
|
FormatSqlVariant | Formats an object as SqlVariant type. (Geerbt von SqlSmoObject.) |
|
GenerateAlterEvent() | Generates the alter event with the specified value. (Geerbt von SqlSmoObject.) |
|
GenerateAlterEvent(Urn, Object) | Generates alter event with the specified URN and inner object value. (Geerbt von SqlSmoObject.) |
|
GetBraketNameForText | Gets the bracket name for the text. (Geerbt von ScriptNameObjectBase.) |
|
GetContextDB | Gets the context database that is associated with this object. (Geerbt von SqlSmoObject.) |
|
GetDBName | Gets the database name that is associated with the object. (Geerbt von SqlSmoObject.) |
|
GetFragOptionString | Gets a FragmentationOption object as a string value. (Geerbt von SqlSmoObject.) |
|
GetHashCode | (Geerbt von Object.) |
|
GetIsSystemNamed | Gets a Boolean value that specifies whether the system is named. (Geerbt von ScriptNameObjectBase.) |
|
GetIsTextDirty | Determines whether the text value is consistent with stored value. (Geerbt von ScriptNameObjectBase.) |
|
GetPropValue | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetRealValue | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.) |
|
GetServerObject | Gets the server of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.) |
|
GetTextBody() | Returns the text body. (Geerbt von ScriptNameObjectBase.) |
|
GetTextBody(Boolean) | Returns the text body. (Geerbt von ScriptNameObjectBase.) |
|
GetTextHeader | Returns the text header. (Geerbt von ScriptNameObjectBase.) |
|
GetTextMode | Determines whether the script name is using text mode. (Geerbt von ScriptNameObjectBase.) |
|
GetTextProperty | Gets the text of the object, if not available, throw appropriate exception based on the state of the object. (Geerbt von ScriptNameObjectBase.) |
|
GetType | (Geerbt von Object.) |
|
GetUrnRecursive(StringBuilder) | Assigns an Urn object of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | Assigns an Urn object of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
ImplInitialize | Initializes the fields of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
Initialize() | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
|
IsEventSetDirty | Returns a Boolean value that specifies whether the database data definition language (DDL) trigger event set has been modified but not yet persisted on the instance of Microsoft SQL Server. |
|
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (Geerbt von ScriptNameObjectBase.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (Geerbt von SqlSmoObject.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Geerbt von SqlSmoObject.) |
|
IsVersion80SP3 | Determines whether the version of SQL Server is SQL Server 2000 with SP3. (Geerbt von SqlSmoObject.) |
|
IsVersion90AndAbove | Determines whether the version of SQL Server is SQL Server 2005 or later. (Geerbt von SqlSmoObject.) |
|
MarkDropped | Sets the SqlSmoState to dropped. (Geerbt von SqlSmoObject.) |
|
MarkForDropImpl | Sets the SqlSmoState for drop operation. (Geerbt von SqlSmoObject.) |
|
MemberwiseClone | (Geerbt von Object.) |
|
PostAlter | The method that is activated after the SqlSmoObject is altered. (Geerbt von SqlSmoObject.) |
|
PostCreate | The method that is activated after the SqlSmoObject is created. (Geerbt von SqlSmoObject.) |
|
PostDrop | The method that is activated after the SqlSmoObject is dropped. (Geerbt von SqlSmoObject.) |
|
Refresh | Refreshes the script name. (Geerbt von ScriptNameObjectBase.) |
|
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Geerbt von NamedSmoObject.) |
|
RenameImplWorker | Nur für Informationszwecke identifiziert. Nicht unterstützt. Zukünftige Kompatibilität wird nicht sichergestellt. (Geerbt von NamedSmoObject.) |
|
Script() | Generates a Transact-SQL script that can be used to re-create the database data definition language (DDL) trigger. |
|
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the database data definition language (DDL) trigger as specified by the script options. |
|
ScriptHeader | Generates a Transact-SQL script that can be used to re-create the database data definition language (DDL) trigger header as specified by the script options. |
|
ScriptImpl() | Gets a collection of scripts of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
ScriptImpl(ScriptingOptions) | Gets a collection of scripts of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
SetCollectionTextMode | Sets the collection text mode. (Geerbt von ScriptNameObjectBase.) |
|
SetIsSystemNamed | Sets a Boolean value that specifies whether the system is named. (Geerbt von ScriptNameObjectBase.) |
|
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (Geerbt von SqlSmoObject.) |
|
SetSchemaOwned | Sets the schema owned value. (Geerbt von NamedSmoObject.) |
|
SetTextBody | Specifies the text body. (Geerbt von ScriptNameObjectBase.) |
|
SetTextHeader | Specifies the text header. (Geerbt von ScriptNameObjectBase.) |
|
SetTextMode | Specifies the text mode. (Geerbt von ScriptNameObjectBase.) |
|
SwitchTextMode | Switches the text mode. (Geerbt von ScriptNameObjectBase.) |
|
ThrowIfTextIsDirtyForAlter | Throws an exception of text has been modified and not persisted. (Geerbt von ScriptNameObjectBase.) |
|
ToString | Returns a String that represents the referenced object. (Geerbt von SqlSmoObject.) |
|
TouchImpl | Not implemented. (Geerbt von SqlSmoObject.) |
|
UnbindDefaultImpl | Unbinds the default columns of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
UnbindRuleImpl | Unbinds rules of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
Validate | Validates the state of an object. (Geerbt von SmoObjectBase.) |
Zum Anfang
Ereignisse
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliches Ereignis") |
PropertyChanged | Represents the event that occurs when a property is changed. (Geerbt von SqlSmoObject.) |
|
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (Geerbt von SqlSmoObject.) |
Zum Anfang
Felder
| Name | Beschreibung | |
|---|---|---|
.gif "Geschütztes Feld") |
m_ExtendedProperties | Represents a property that is defined to extend the properties provided by a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
singletonParent | Represents the singleton parent. (Geerbt von SqlSmoObject.) |
Zum Anfang
Explizite Schnittstellenimplementierungen
| Name | Beschreibung | |
|---|---|---|
.gif "Explizite Schnittstellenimplementierung") .gif "Private Methode") |
IAlienObject.Discover | Discovers any dependencies. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetDomainRoot | Returns the root of the domain. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetParent | Gets the parent of this object. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetPropertyType | Gets the type of the specified property. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetPropertyValue | Gets the value of the specified property. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Geerbt von SqlSmoObject.) |
|
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (Geerbt von SqlSmoObject.) |
|
IAlienObject.SetPropertyValue | Sets the property value. (Geerbt von SqlSmoObject.) |
|
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (Geerbt von SqlSmoObject.) |
Zum Anfang
Hinweise
DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events.
SQL Server Management Objects (SMO) provides programmatic access to allow management of all DDL trigger functionality with the DatabaseDdlTrigger object and the ServerDdlTrigger object.
Database DDL triggers respond to events within the scope of the database and server DDL triggers respond to events within the scope of the SQL Server instance.
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
Siehe auch
Verweis
Microsoft.SqlServer.Management.Smo-Namespace