SQL-DMO Object Type Constants (SQLDMO_OBJECT_TYPE)
SQL-DMO object type constants enumerate the kind of Microsoft® SQL Server™ element referenced by a specific SQL-DMO object. For example, the TypeOf property returns an object type constant.
Object type constants are used optionally by listing methods to constrain list or query result set membership.
| Constant | Value | Description |
|---|---|---|
| SQLDMOObj_Alert | 2109440 | Object references a SQL Server Agent service alert. |
| SQLDMOObj_AlertSystem | 2101248 | Object is an AlertSystem object giving access to SQL Server Agent service parameters. |
| SQLDMOObj_AllButSystemObjects | 5119 | List or query result set membership includes all but SQL Server system objects. |
| SQLDMOObj_AllDatabaseObjects | 4607 | List or query result set membership includes Microsoft SQL Server system and user database objects. |
| SQLDMOObj_AllDatabaseUserObjects | 4605 | List or query result set membership includes only user database objects. |
| SQLDMOObj_Application | 0 | Object is the SQL-DMO Application object. |
| SQLDMOObj_AutoProperty | 188416 | Object is a Property object exposed for OLE Automation controllers. |
| SQLDMOObj_Backup | 184320 | Object is a Backup object defining a possible database or log backup operation. |
| SQLDMOObj_BackupDevice | 139264 | Object references a SQL Server backup device. |
| SQLDMOObj_BulkCopy | 204800 | Object is a BulkCopy object defining a possible table export or import operation. |
| SQLDMOObj_Category | 2134016 | Object references a SQL Server Agent service alert, operator, or job category. |
| SQLDMOObj_Check | 49152 | Object references an integrity constraint. |
| SQLDMOObj_Column | 24576 | Object references a column in a table. |
| SQLDMOObj_Configuration | 159744 | Object references a configuration parameter. |
| SQLDMOObj_ConfigValue | 163840 | Object references a configuration parameter value. |
| SQLDMOObj_Database | 135168 | Object references a database. |
| SQLDMOObj_DatabaseRole | 225280 | Object references a database role. |
| SQLDMOObj_DBFile | 212992 | Object references an operating system file implementing database storage. |
| SQLDMOObj_DBObject | 28672 | Object is a DBObject object visible in lists and used in database transfer operations. |
| SQLDMOObj_DBOption | 32768 | Object references a database option. |
| SQLDMOObj_Default | 64 | Object references a default. |
| SQLDMOObj_DistributionArticle | 1134592 | Object references a heterogeneous replication task. |
| SQLDMOObj_DistributionDatabase | 1118208 | Object references a database used for replication distribution. |
| SQLDMOObj_DistributionPublication | 1130496 | Object references a publication maintained at the Distributor. |
| SQLDMOObj_DistributionPublisher | 1105920 | Object references an instance of SQL Server acting as a Distributor for published data. |
| SQLDMOObj_DistributionSubscription | 1138688 | Object references a push subscription initiated by a Distributor. |
| SQLDMOObj_Distributor | 1097728 | Object references an instance of SQL Server acting as a replication Distributor. |
| SQLDMOObj_DRIDefault | 53248 | Object references a SQL Server column-specific default value. |
| SQLDMOObj_FileGroup | 208896 | Object references a SQL Server database filegroup. |
| SQLDMOObj_FullTextCatalog | 266240 | Object references a Microsoft Search full-text catalog. |
| SQLDMOObj_FullTextService | 270336 | Object references the Search service. |
| SQLDMOObj_Index | 16384 | Object references an index. |
| SQLDMOObj_IntegratedSecurity | 45056 | Object is an IntegratedSecurity object defining name mapping applied by SQL Server when using Windows NT Authentication. |
| SQLDMOObj_Job | 2117632 | Object references a SQL Server Agent service job. |
| SQLDMOObj_JobFilter | 2166784 | Object is a JobFilter object controlling job enumerating methods of the JobServer object. |
| SQLDMOObj_JobHistoryFilter | 2170880 | Object is a JobHistoryFilter object controlling job history enumerating methods of the JobServer object. |
| SQLDMOObj_JobSchedule | 2174976 | Object references a SQL Server Agent service schedule. |
| SQLDMOObj_JobServer | 2105344 | Object references a SQL Server Agent service. |
| SQLDMOObj_JobStep | 2121728 | Object references a SQL Server Agent service job step. |
| SQLDMOObj_Key | 20480 | Object references a primary or foreign key. |
| SQLDMOObj_LinkedServer | 233472 | Object references a SQL Server 2000 linked server. |
| SQLDMOObj_LinkedServerLogin | 262144 | Object references a SQL Server linked server login. |
| SQLDMOObj_LogFile | 217088 | Object references an operating system file implementing a SQL Server database log. |
| SQLDMOObj_Login | 143360 | Object references a SQL Server login. |
| SQLDMOObj_Language | 147456 | Object references a SQL Server language record. |
| SQLDMOObj_MergeArticle | 1073152 | Object references a merge replication task. |
| SQLDMOObj_MergePublication | 1069056 | Object references merge replication tasks grouped as a publication. |
| SQLDMOObj_MergePullSubscription | 1081344 | Object references a subscription to a merge replication publication. The Subscriber controls replication synchronization attempts. |
| SQLDMOObj_MergeSubscription | 1077248 | Object references a subscription to a merge replication publication. The Publisher controls replication synchronization attempts. |
| SQLDMOObj_MergeSubsetFilter | 1142784 | Object references a merge replication partitioning filter. |
| SQLDMOObj_Operator | 2113536 | Object references a SQL Server Agent service operator. |
| SQLDMOObj_Permission | 40960 | Object is a Permission object exposing SQL Server object-level security. |
| SQLDMOObj_ProcedureParameter | 36864 | Object references a parameter of a stored procedure. |
| SQLDMOObj_Publisher | 1089536 | Object references a SQL Server Agent service alert. |
| SQLDMOObj_QueryResults | 167936 | Object is a QueryResults object. |
| SQLDMOObj_RegisteredServer | 200704 | Object references a registry entry listing an instance of SQL Server. |
| SQLDMOObj_RegisteredSubscriber | 1110016 | Object references a replication Subscriber. |
| SQLDMOObj_Registry | 176128 | Object is a Registry object exposing registry-maintained data about an instance of SQL Server. |
| SQLDMOObj_RemoteLogin | 155648 | Object references a mapping for access by another SQL Server instance. |
| SQLDMOObj_RemoteServer | 151552 | Object references an instance of SQL Server allowed access for remote procedure execution. |
| SQLDMOObj_Replication | 1085440 | Object is the Replication object. |
| SQLDMOObj_ReplicationDatabase | 1114112 | Object references a SQL Server database replicated in merge or transactional publications. |
| SQLDMOObj_ReplicationSecurity | 1101824 | Object is a ReplicationSecurity object specifying login authentication for replication Publishers and Subscribers. |
| SQLDMOObj_ReplicationStoredProcedure | 1126400 | Object references a stored procedure replicated in a transactional or merge article. |
| SQLDMOObj_ReplicationTable | 1122304 | Object references a table replicated in a transactional or merge article. |
| SQLDMOObj_Restore | 229376 | Object is a Restore object used to specify a database or transaction log operation. |
| SQLDMOObj_Rule | 128 | Object references a rule. |
| SQLDMOObj_Schedule | 2162688 | Object is a Schedule object used to specify run times for administrative and replication tasks. |
| SQLDMOObj_ServerGroup | 192512 | Object references a registry-based grouping for servers. |
| SQLDMOObj_ServerRole | 221184 | Object references a fixed server role. |
| SQLDMOObj_SQLServer | 131072 | Object is a SQLServer object. |
| SQLDMOObj_StoredProcedure | 16 | Object references a stored procedure. |
| SQLDMOObj_Subscriber | 1093632 | Object references a Subscriber for replicated data. |
| SQLDMOObj_SystemDatatype | 4096 | Object references a SQL Server base data type. |
| SQLDMOObj_SystemTable | 2 | Object references a system table. |
| SQLDMOObj_TargetServer | 2125824 | Object references a SQL Server Agent service target server. |
| SQLDMOObj_TargetServerGroup | 2129920 | Object references a SQL Server Agent service target server group. |
| SQLDMOObj_TransactionLog | 172032 | Object is a TransactionLog object exposing the properties of SQL Server database transaction logging. |
| SQLDMOObj_TransArticle | 1056768 | Object references a transactional replication task. |
| SQLDMOObj_Transfer | 180224 | Object is a Transfer object used to move data and objects from one SQL Server database to another. |
| SQLDMOObj_TransPublication | 1069056 | Object references a publication grouping transactional replication tasks. |
| SQLDMOObj_TransPullSubscription | 1064960 | Object references a subscription to a transactional replication publication. The Subscriber controls synchronization attempts. |
| SQLDMOObj_TransSubscription | 1060864 | Object references a subscription to a transactional replication publication. The Publisher controls synchronization attempts. |
| SQLDMOObj_Trigger | 256 | Object references a trigger. |
| SQLDMOObj_Unknown | 16384 | Object type is unknown. Indicates an error condition. |
| SQLDMOObj_User | 8192 | Object references a SQL Server database user. |
| SQLDMOObj_UserDefinedDatatype | 4096 | Object references a SQL Server user-defined data type. |
| SQLDMOObj_UserDefinedFunction | 1 | Object references a user-defined function. |
| SQLDMOObj_UserTable | 8 | Object references a SQL Server user-defined table. |
| SQLDMOObj_View | 4 | Object references a view. |