Export (0) Print
Expand All
Expand Minimize

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)

[FlagsAttribute]
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.
DatabaseAuditSpecificationThe object type is a DatabaseAuditSpecification type.
DatabaseEncryptionKeyThe object type is a DatabaseEncryptionKey type.
DatabaseRoleThe object type is a DatabaseRole type.
DatabaseSegmentThe object type is a DatabaseSegment type.
DefaultThe object type is a Default object type.
ExtendedStoredProcedureThe object type is an ExtendedStoredProcedure object type.
FederationThe object type is a Federation object type.
FullTextCatalogThe object type is a FullTextCatalog object type.
FullTextStopListThe object type is a FullTextStoplist 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.
PlanGuideThe object type is a PlanGuide 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.
SearchPropertyListThe object type is a SearchPropertyList object type.
SequenceThe object type is a Sequence 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.
UserDefinedTableTypesThe object type is a UserDefinedTableTypes 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft