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.