DatabaseObjectTypes Enumeration

The DatabaseObjectTypes enumeration is a list of constant values that specifies the types of database object.

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

public enum DatabaseObjectTypes
/** @attribute FlagsAttribute() */ 
public enum DatabaseObjectTypes
public enum DatabaseObjectTypes

Member nameDescription
AllAll object types are represented.
ApplicationRoleThe object type is an ApplicationRole type.
AsymmetricKeyThe object type is an AsymmetricKey type.
CertificateThe object type is a Certificate type.
DatabaseRoleThe object type is a DatabaseRole type.
DefaultThe object type is a Default object type.
ExtendedStoredProcedureThe object type is an ExtendedStoredProcedure object type.
FullTextCatalogThe object type is a FullTextCatalog object type.
MessageTypeThe object type is a MessageType object type.
PartitionFunctionThe object type is a PartitionFunction object type.
PartitionSchemeThe object type is a PartitionScheme object type.
RemoteServiceBindingThe object type is a RemoteServiceBinding object type.
RuleThe object type is a Rule object type.
SchemaThe object type is a Schema object type.
ServiceBrokerThe object type is a ServiceBroker object type.
ServiceContractThe object type is a ServiceContract object type.
ServiceQueueThe object type is a ServiceQueue object type.
ServiceRouteThe object type is a ServiceRoute object type.
SqlAssemblyThe object type is a SqlAssembly object type.
StoredProcedureThe object type is a StoredProcedure object type.
SymmetricKeyThe object type is a SymmetricKey type.
SynonymThe object type is a Synonym object type.
TableThe object type is a Table object type.
UserThe object type is a User object type.
UserDefinedAggregateThe object type is a UserDefinedAggregate object type.
UserDefinedDataTypeThe object type is a UserDefinedDataType object type.
UserDefinedFunctionThe object type is a UserDefinedFunction object type.
UserDefinedTypeThe object type is a UserDefinedType object type.
ViewThe object type is a View object type.
XmlSchemaCollectionThe object type is an XmlSchemaCollection object type.

The DatabaseObjectTypes enumeration class is served by the EnumObjects method.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions