ObjectType Enum

Definition

Defines object types that exist in SQL Server.

public enum ObjectType
type ObjectType = 
Public Enum ObjectType
Inheritance
ObjectType

Fields

Name Value Description
Aggregates 0

Aggregate objects APPLICATION-SCOPED

ApplicationRoles 1

Application role objects APPLICATION-SCOPED

Assemblies 2

Assembly objects APPLICATION-SCOPED

AssemblyFiles 3

Assembly files APPLICATION-SCOPED

AsymmetricKeys 4

Asymmetric key objects APPLICATION-SCOPED

BrokerPriorities 5

Broker priority objects APPLICATION-SCOPED

Certificates 6

Certificate objects APPLICATION-SCOPED

ColumnEncryptionKeys 7

Always Encrypted column encryption key objects APPLICATION-SCOPED

ColumnMasterKeys 8

Always Encrypted column master key objects APPLICATION-SCOPED

Contracts 9

Contract objects APPLICATION-SCOPED

DatabaseOptions 10

Database options APPLICATION-SCOPED

DatabaseRoles 11

Database role objects APPLICATION-SCOPED

DatabaseTriggers 12

Database DDL trigger objects APPLICATION-SCOPED

Defaults 13

Default objects APPLICATION-SCOPED

ExtendedProperties 14

Extended property objects APPLICATION-SCOPED

ExternalDataSources 15

External data source objects APPLICATION-SCOPED

ExternalFileFormats 16

External file format objects APPLICATION-SCOPED

ExternalTables 17

External table objects APPLICATION-SCOPED

Filegroups 18

Filegroup objects APPLICATION-SCOPED

Files 19

File objects APPLICATION-SCOPED

FileTables 19

FileTable objects APPLICATION-SCOPED

FullTextCatalogs 20

Full-text catalog objects APPLICATION-SCOPED

FullTextStoplists 21

Full-text stoplist objects APPLICATION-SCOPED

MessageTypes 22

Message type objects APPLICATION-SCOPED

PartitionFunctions 23

Partition function objects APPLICATION-SCOPED

PartitionSchemes 24

Partition scheme objects APPLICATION-SCOPED

Permissions 25

Permission objects APPLICATION-SCOPED

Queues 26

Queue objects APPLICATION-SCOPED

RemoteServiceBindings 27

Remote service binding objects APPLICATION-SCOPED

RoleMembership 28

Role membership objects APPLICATION-SCOPED

Rules 29

Rule objects APPLICATION-SCOPED

ScalarValuedFunctions 30

Scalar valued function objects APPLICATION-SCOPED

SearchPropertyLists 31

Search property list objects APPLICATION-SCOPED

SecurityPolicies 32

Security policy objects APPLICATION-SCOPED

Sequences 33

Sequence objects APPLICATION-SCOPED

Services 34

Service objects APPLICATION-SCOPED

Signatures 35

Signature objects APPLICATION-SCOPED

StoredProcedures 36

Stored procedure objects APPLICATION-SCOPED

SymmetricKeys 37

Symmetric key objects APPLICATION-SCOPED

Synonyms 38

Synonym objects APPLICATION-SCOPED

Tables 39

Table objects APPLICATION-SCOPED

TableValuedFunctions 40

Table valued function objects APPLICATION-SCOPED

UserDefinedDataTypes 41

User defined data type (non-CLR) objects APPLICATION-SCOPED

UserDefinedTableTypes 42

User defined table type objects APPLICATION-SCOPED

ClrUserDefinedTypes 43

User defined type (CLR) objects APPLICATION-SCOPED

Users 44

User objects APPLICATION-SCOPED

Views 45

View objects APPLICATION-SCOPED

XmlSchemaCollections 46

Xml schema collection objects APPLICATION-SCOPED

Audits 47

Audit objects NON-APPLICATION-SCOPED

Credentials 48

Credential objects NON-APPLICATION-SCOPED

CryptographicProviders 49

Cryptographic provider objects NON-APPLICATION-SCOPED

DatabaseAuditSpecifications 50

Database audit specification objects NON-APPLICATION-SCOPED

DatabaseEncryptionKeys 51

Database encryption keys NON-APPLICATION-SCOPED

DatabaseScopedCredentials 52

Database scoped credential objects NON-APPLICATION-SCOPED

Endpoints 53

Endpoint objects NON-APPLICATION-SCOPED

ErrorMessages 54

Error message objects NON-APPLICATION-SCOPED

EventNotifications 55

Error notification objects NON-APPLICATION-SCOPED

EventSessions 56

Event session objects NON-APPLICATION-SCOPED

LinkedServerLogins 57

Linked server login objects NON-APPLICATION-SCOPED

LinkedServers 58

Linked server objects NON-APPLICATION-SCOPED

Logins 59

Login objects NON-APPLICATION-SCOPED

MasterKeys 60

Master keys NON-APPLICATION-SCOPED

Routes 61

Route objects NON-APPLICATION-SCOPED

ServerAuditSpecifications 62

Server audit specification objects NON-APPLICATION-SCOPED

ServerRoleMembership 63

Server role membership objects NON-APPLICATION-SCOPED

ServerRoles 64

Server role objects NON-APPLICATION-SCOPED

ServerTriggers 65

Server DDL trigger objects NON-APPLICATION-SCOPED

ExternalStreams 67

External stream objects APPLICATION-SCOPED

ExternalStreamingJobs 68

External streaming jobs APPLICATION-SCOPED

DatabaseWorkloadGroups 69

Workload Groups for DW APPLICATION-SCOPED

WorkloadClassifiers 70

Workload Classifiers for DW APPLICATION-SCOPED

ExternalLibraries 71

External library objects APPLICATION-SCOPED

ExternalLanguages 72

External language objects APPLICATION-SCOPED

Applies to