SchemaName - property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

SchemaName in other namespaces

List of classes with SchemaName local property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

propertyClassOrigin
SchemaNameADD_SIGNATURE_SCHEMA_OBJECTADD_SIGNATURE_SCHEMA_OBJECT
SchemaNameALTER_AUTHORIZATION_DATABASEALTER_AUTHORIZATION_DATABASE
SchemaNameBROKER_QUEUE_DISABLEDBROKER_QUEUE_DISABLED
SchemaNameDDL_DEFAULT_EVENTSDDL_DEFAULT_EVENTS
SchemaNameDDL_EXTENDED_PROPERTY_EVENTSDDL_EXTENDED_PROPERTY_EVENTS
SchemaNameDDL_FUNCTION_EVENTSDDL_FUNCTION_EVENTS
SchemaNameDDL_GDR_DATABASE_EVENTSDDL_GDR_DATABASE_EVENTS
SchemaNameDDL_PROCEDURE_EVENTSDDL_PROCEDURE_EVENTS
SchemaNameDDL_QUEUE_EVENTSDDL_QUEUE_EVENTS
SchemaNameDDL_RULE_EVENTSDDL_RULE_EVENTS
SchemaNameDDL_SCHEMA_EVENTSDDL_SCHEMA_EVENTS
SchemaNameDDL_SEQUENCE_EVENTSDDL_SEQUENCE_EVENTS
SchemaNameDDL_SYNONYM_EVENTSDDL_SYNONYM_EVENTS
SchemaNameDDL_TABLE_VIEW_EVENTSDDL_TABLE_VIEW_EVENTS
SchemaNameDDL_TRIGGER_EVENTSDDL_TRIGGER_EVENTS
SchemaNameDDL_TYPE_EVENTSDDL_TYPE_EVENTS
SchemaNameDDL_XML_SCHEMA_COLLECTION_EVENTSDDL_XML_SCHEMA_COLLECTION_EVENTS
SchemaNameDROP_SIGNATURE_SCHEMA_OBJECTDROP_SIGNATURE_SCHEMA_OBJECT
SchemaNameQUEUE_ACTIVATIONQUEUE_ACTIVATION
SchemaNameRENAMERENAME

List of classes with SchemaName derived property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

propertyClassOrigin
SchemaNameALTER_EXTENDED_PROPERTYDDL_EXTENDED_PROPERTY_EVENTS
SchemaNameALTER_FULLTEXT_INDEXDDL_TABLE_VIEW_EVENTS
SchemaNameALTER_FUNCTIONDDL_FUNCTION_EVENTS
SchemaNameALTER_INDEXDDL_TABLE_VIEW_EVENTS
SchemaNameALTER_PROCEDUREDDL_PROCEDURE_EVENTS
SchemaNameALTER_QUEUEDDL_QUEUE_EVENTS
SchemaNameALTER_SCHEMADDL_SCHEMA_EVENTS
SchemaNameALTER_SEQUENCEDDL_SEQUENCE_EVENTS
SchemaNameALTER_TABLEDDL_TABLE_VIEW_EVENTS
SchemaNameALTER_TRIGGERDDL_TRIGGER_EVENTS
SchemaNameALTER_VIEWDDL_TABLE_VIEW_EVENTS
SchemaNameALTER_XML_SCHEMA_COLLECTIONDDL_XML_SCHEMA_COLLECTION_EVENTS
SchemaNameBIND_DEFAULTDDL_DEFAULT_EVENTS
SchemaNameBIND_RULEDDL_RULE_EVENTS
SchemaNameCREATE_DEFAULTDDL_DEFAULT_EVENTS
SchemaNameCREATE_EXTENDED_PROPERTYDDL_EXTENDED_PROPERTY_EVENTS
SchemaNameCREATE_FULLTEXT_INDEXDDL_TABLE_VIEW_EVENTS
SchemaNameCREATE_FUNCTIONDDL_FUNCTION_EVENTS
SchemaNameCREATE_INDEXDDL_TABLE_VIEW_EVENTS
SchemaNameCREATE_PROCEDUREDDL_PROCEDURE_EVENTS
SchemaNameCREATE_QUEUEDDL_QUEUE_EVENTS
SchemaNameCREATE_RULEDDL_RULE_EVENTS
SchemaNameCREATE_SCHEMADDL_SCHEMA_EVENTS
SchemaNameCREATE_SEQUENCEDDL_SEQUENCE_EVENTS
SchemaNameCREATE_SPATIAL_INDEXDDL_TABLE_VIEW_EVENTS
SchemaNameCREATE_STATISTICSDDL_TABLE_VIEW_EVENTS
SchemaNameCREATE_SYNONYMDDL_SYNONYM_EVENTS
SchemaNameCREATE_TABLEDDL_TABLE_VIEW_EVENTS
SchemaNameCREATE_TRIGGERDDL_TRIGGER_EVENTS
SchemaNameCREATE_TYPEDDL_TYPE_EVENTS
SchemaNameCREATE_VIEWDDL_TABLE_VIEW_EVENTS
SchemaNameCREATE_XML_INDEXDDL_TABLE_VIEW_EVENTS
SchemaNameCREATE_XML_SCHEMA_COLLECTIONDDL_XML_SCHEMA_COLLECTION_EVENTS
SchemaNameDDL_INDEX_EVENTSDDL_TABLE_VIEW_EVENTS
SchemaNameDDL_STATISTICS_EVENTSDDL_TABLE_VIEW_EVENTS
SchemaNameDDL_TABLE_EVENTSDDL_TABLE_VIEW_EVENTS
SchemaNameDDL_VIEW_EVENTSDDL_TABLE_VIEW_EVENTS
SchemaNameDENY_DATABASEDDL_GDR_DATABASE_EVENTS
SchemaNameDROP_DEFAULTDDL_DEFAULT_EVENTS
SchemaNameDROP_EXTENDED_PROPERTYDDL_EXTENDED_PROPERTY_EVENTS
SchemaNameDROP_FULLTEXT_INDEXDDL_TABLE_VIEW_EVENTS
SchemaNameDROP_FUNCTIONDDL_FUNCTION_EVENTS
SchemaNameDROP_INDEXDDL_TABLE_VIEW_EVENTS
SchemaNameDROP_PROCEDUREDDL_PROCEDURE_EVENTS
SchemaNameDROP_QUEUEDDL_QUEUE_EVENTS
SchemaNameDROP_RULEDDL_RULE_EVENTS
SchemaNameDROP_SCHEMADDL_SCHEMA_EVENTS
SchemaNameDROP_SEQUENCEDDL_SEQUENCE_EVENTS
SchemaNameDROP_STATISTICSDDL_TABLE_VIEW_EVENTS
SchemaNameDROP_SYNONYMDDL_SYNONYM_EVENTS
SchemaNameDROP_TABLEDDL_TABLE_VIEW_EVENTS
SchemaNameDROP_TRIGGERDDL_TRIGGER_EVENTS
SchemaNameDROP_TYPEDDL_TYPE_EVENTS
SchemaNameDROP_VIEWDDL_TABLE_VIEW_EVENTS
SchemaNameDROP_XML_SCHEMA_COLLECTIONDDL_XML_SCHEMA_COLLECTION_EVENTS
SchemaNameGRANT_DATABASEDDL_GDR_DATABASE_EVENTS
SchemaNameREVOKE_DATABASEDDL_GDR_DATABASE_EVENTS
SchemaNameUNBIND_DEFAULTDDL_DEFAULT_EVENTS
SchemaNameUNBIND_RULEDDL_RULE_EVENTS
SchemaNameUPDATE_STATISTICSDDL_TABLE_VIEW_EVENTS

Code samples for SchemaName property

The class CREATE_TRIGGER is abstract and serves only as a base for new classes.

Get a Class as object

Short VB Script code to get the abstract class CREATE_TRIGGER.
See in another language: C#, VB.Net.
'https://wutils.com/wmi/
Dim wmiClass, oProperty
Set wmiClass = GetObject( _
 "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:" + _
 "CREATE_TRIGGER")

'get some class property 
Wscript.Echo wmiClass.properties_("SchemaName").Origin 'or other property name, see properties

'Check if the class is singleton
Wscript.Echo wmiClass.Path_.IsSingleton

'Get number of methods in the class
Wscript.Echo wmiClass.Methods_.Count

'List class properties
For Each oProperty In wmiClass.properties_
	'get property name and origin. Property value in the class is null, of course.
	Wscript.Echo oProperty.Name, oProperty.Origin, oProperty.Value
Next 

InstancesOf

List of all instances, wmi class CREATE_TRIGGER.
'https://wutils.com/wmi/
Dim oWMI, Instances, Instance

'Get base WMI object, "." means computer name (local)
Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER")

'Get instances of CREATE_TRIGGER - all instances of this class and derived classes 
Set Instances = oWMI.InstancesOf("CREATE_TRIGGER")


'Enumerate instances  
For Each Instance In Instances 
  'Do something with the instance
  Wscript.Echo Instance.SchemaName 'or other property name
Next 'Instance
comments powered by Disqus
WUtils.com