ObjectType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Defines object types that exist in SQL Server.
public enum ObjectTypetype 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 |