SDAC

TMSObjectType Enumeration

Enumerates the object types supported by TMSMetadata.

Unit

MSAccess

Syntax

TMSObjectType = (otDatabases, otTables, otTableConstraints, otColumns, otIndexes, otStoredProcs, otStoredProcParams, otColumnPrivileges, otForeignKeys, otPrimaryKeys, otLinkedServers, otServerTypes, otSchemata, otStatistics, otAliases, otSynonyms, otViews, otSystemTables, otGlobalTempTables, otLocalTempTables, otSystemViews, otAliasesInfo, otTablesInfo, otSynonymsInfo, otSystemTablesInfo, otViewsInfo, otGlobalTempTablesInfo, otLocalTempTablesInfo, otExternalTablesInfo, otSystemViewsInfo, otTablePrivileges, otAssemblies, otAssemblyDependencies, otUserTypes, otXMLCollections, otCheckConstraints, otCheckConstraintsByTable, otTableStatistics);

Values

Value Meaning
otAliases Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES Rowset
otAliasesInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otAssemblies Restrictions: DatabaseName, SchemaName, AssemblyName, AssemblyID Rowset name: DBSCHEMA_SQL_ASSEMBLIES Rowset
otAssemblyDependencies Restrictions: DatabaseName, SchemaName, AssemblyID, ReferencedAssemblyID Rowset name: DBSCHEMA_SQL_ASSEMBLY_DEPENDENCIES Rowset
otCheckConstraints Restrictions: DatabaseName, SchemaName, ConstraintName Rowset name: CHECK_CONSTRAINTS Rowset
otCheckConstraintsByTable Restrictions: DatabaseName, SchemaName, TableName, ConstraintName Rowset name: CHECK_CONSTRAINTS_BY_TABLE Rowset
otColumnPrivileges Restrictions: DatabaseName, SchemaName, TableName, ColumnName Rowset name: COLUMN_PRIVILEGES Rowset
otColumns Restrictions: DatabaseName, SchemaName, TableName, ColumnName Rowset name: COLUMNS Rowset
otDatabases Restrictions: DatabaseName Rowset name: CATALOGS Rowset
otExternalTablesInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otForeignKeys Restrictions: DatabaseName, SchemaName, TableName Rowset name: FOREIGN_KEYS Rowset
otGlobalTempTables Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES Rowset
otGlobalTempTablesInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otIndexes Restrictions: DatabaseName, SchemaName, TableName Rowset name: INDEXES Rowset
otLinkedServers Restrictions: LinkedServer Rowset name: DBSCHEMA_LINKEDSERVERS Rowset
otLocalTempTables Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES Rowset
otLocalTempTablesInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otPrimaryKeys Restrictions: DatabaseName, SchemaName, TableName Rowset name: PRIMARY_KEYS Rowset
otSchemata Restrictions: DatabaseName, SchemaName Rowset name: SCHEMATA Rowset
otServerTypes Restrictions: Rowset name: PROVIDER_TYPES Rowset
otStatistics Restrictions: DatabaseName, SchemaName, TableName Rowset name: STATISTICS Rowset
otStoredProcParams Restrictions: DatabaseName, SchemaName, TableName Rowset name: STATISTICS Rowset
otStoredProcs Restrictions: DatabaseName, SchemaName, StoredProcName Rowset name: PROCEDURES Rowset
otSynonyms Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES Rowset
otSynonymsInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otSystemTables Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES Rowset
otSystemTablesInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otSystemViews Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES Rowset
otSystemViewsInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otTableConstraints Restrictions: DatabaseName, SchemaName, TableName, ConstraintName Rowset name: TABLE_CONSTRAINTS Rowset
otTablePrivileges Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLE_PRIVILEGES Rowset
otTables Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES Rowset
otTablesInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otTableStatistics Restrictions: DatabaseName, SchemaName, TableName, StatisticsName Rowset name: TABLE_STATISTICS Rowset
otUserTypes Restrictions: DatabaseName, SchemaName, UDTName Rowset name: DBSCHEMA_SQL_USER_TYPES Rowset
otViews Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES Rowset
otViewsInfo Restrictions: DatabaseName, SchemaName, TableName Rowset name: TABLES_INFO Rowset
otXMLCollections Restrictions: DatabaseName, SchemaName, SchemaCollectionName, TargetNamespaceURI Rowset name: DBSCHEMA_XML_COLLECTIONS Rowset

Remarks

Every member of this enumeration specifies restrictions and has representation in the MSDN OLE DB schema rowset name.

© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback