Trigger.CreateDate Property

Gets the date and time when the trigger was created.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property CreateDate As DateTime 
    Get
'Usage
Dim instance As Trigger 
Dim value As DateTime 

value = instance.CreateDate
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public DateTime CreateDate { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property DateTime CreateDate {
    DateTime get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member CreateDate : DateTime
function get CreateDate () : DateTime

Property Value

Type: System.DateTime
A DateTime system object value that specifies the time and date when the trigger was created.

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

Trigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DML Triggers

CREATE TRIGGER (Transact-SQL)