Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DatabaseObjectTypes Enumeration
Collapse the table of content
Expand the table of content

DatabaseObjectTypes Enumeration

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

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

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

public enum DatabaseObjectTypes

Member nameDescription
ApplicationRoleThe object type is an ApplicationRole type.
ServiceBrokerThe object type is a ServiceBroker object 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.
DatabaseRoleThe object type is a DatabaseRole 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.
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.
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.
SymmetricKeyThe object type is a SymmetricKey type.
CertificateThe object type is a Certificate type.
AsymmetricKeyThe object type is an AsymmetricKey type.
UserDefinedTableTypesThe object type is a UserDefinedTableTypes object type.
PlanGuideThe object type is a PlanGuide object type.
DatabaseEncryptionKeyThe object type is a DatabaseEncryptionKey type.
DatabaseAuditSpecificationThe object type is a DatabaseAuditSpecification type.
FullTextStopListThe object type is a FullTextStoplist object type.
AllAll object types are represented.

The DatabaseObjectTypes enumeration class is served by the EnumObjects method.

Community Additions

© 2015 Microsoft