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>]
type 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.

Community Additions

ADD
Show:
© 2014 Microsoft