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
| 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 |
| Audits | 47 | Audit objects NON-APPLICATION-SCOPED |
| BrokerPriorities | 5 | Broker priority objects APPLICATION-SCOPED |
| Certificates | 6 | Certificate objects APPLICATION-SCOPED |
| ClrUserDefinedTypes | 43 | User defined type (CLR) 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 |
| 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 |
| DatabaseOptions | 10 | Database options APPLICATION-SCOPED |
| DatabaseRoles | 11 | Database role objects APPLICATION-SCOPED |
| DatabaseScopedCredentials | 52 | Database scoped credential objects NON-APPLICATION-SCOPED |
| DatabaseTriggers | 12 | Database DDL trigger objects APPLICATION-SCOPED |
| DatabaseWorkloadGroups | 69 | Workload Groups for DW APPLICATION-SCOPED |
| Defaults | 13 | Default objects 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 |
| ExtendedProperties | 14 | Extended property objects APPLICATION-SCOPED |
| ExternalDataSources | 15 | External data source objects APPLICATION-SCOPED |
| ExternalFileFormats | 16 | External file format objects APPLICATION-SCOPED |
| ExternalLanguages | 72 | External language objects APPLICATION-SCOPED |
| ExternalLibraries | 71 | External library objects APPLICATION-SCOPED |
| ExternalStreamingJobs | 68 | External streaming jobs APPLICATION-SCOPED |
| ExternalStreams | 67 | External stream 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 |
| 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 |
| 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 |
| Routes | 61 | Route objects NON-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 |
| 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 |
| 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 |
| Users | 44 | User objects APPLICATION-SCOPED |
| Views | 45 | View objects APPLICATION-SCOPED |
| WorkloadClassifiers | 70 | Workload Classifiers for DW APPLICATION-SCOPED |
| XmlSchemaCollections | 46 | Xml schema collection objects APPLICATION-SCOPED |