Database Properties
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Name | Description | |
---|---|---|
![]() | ActiveConnections | Gets the number of active connections to the database. |
![]() | ActiveDirectory | Obsolete. Gets the information about the Active Directory settings for the database. |
![]() | AnsiNullDefault | Gets or sets a value that specifies whether the ANSI_NULL_DEFAULT database option is active. |
![]() | AnsiNullsEnabled | Gets or sets a value that specifies whether the ANSI_NULLS_ENABLED database option is active. |
![]() | AnsiPaddingEnabled | Gets or sets a value that specifies whether the ANSI_PADDING_ENABLED database option is active. |
![]() | AnsiWarningsEnabled | Gets or sets a value that specifies whether the ANSI_WARNINGS_ENABLED database option is active. |
![]() | ApplicationRoles | Gets a collection of ApplicationRole objects. Each ApplicationRole object represents an application role defined on the database. |
![]() | ArithmeticAbortEnabled | Gets or sets a value that specifies whether the ARITHMETICABORT database option is active. |
![]() | Assemblies | Gets a collection of SqlAssembly objects. Each SqlAssembly object represents an assembly defined on the database. |
![]() | AsymmetricKeys | Gets a collection of AsymmetricKey objects. Each AsymmetricKey object represents an asymmetric key defined on the database. |
![]() | AutoClose | Gets or sets a value that specifies whether the AUTOCLOSE database option is set. |
![]() | AutoCreateIncrementalStatisticsEnabled | Gets a value that specifies whether the incremental statistics are automatically created for the database. |
![]() | AutoCreateStatisticsEnabled | Gets a value that specifies whether statistics are automatically created for the database. |
![]() | AutoShrink | Gets or sets a value that specifies whether the AUTO_SHRINK database option is active. |
![]() | AutoUpdateStatisticsAsync | Gets or sets a value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active. |
![]() | AutoUpdateStatisticsEnabled | Gets or sets a value that specifies whether statistics are automatically updated for the database. |
![]() | AvailabilityDatabaseSynchronizationState | Gets the synchronization state of the availability database. |
![]() | AvailabilityGroupName | Gets the availability group name in the database. |
![]() | AzureEdition | Gets the Azure edition of the database. |
![]() | AzureServiceObjective | Gets the objective of the current subscription. |
![]() | BrokerEnabled | Gets or sets a value that specifies whether the Service Broker service is enabled. |
![]() | CaseSensitive | Gets a value that specifies whether uppercase letters and lowercase letters are evaluated as equal. |
![]() | Certificates | Gets a collection of Certificate objects. Each Certificate object represents a certificate defined on the database. |
![]() | ChangeTrackingAutoCleanUp | Gets or sets a value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled. |
![]() | ChangeTrackingEnabled | Gets or sets a value that specifies whether the CHANGE_TRACKING_VALUE option is enabled. |
![]() | ChangeTrackingRetentionPeriod | Gets or sets the CHANGE_TRACKING_RETENTION_PERIOD value. |
![]() | ChangeTrackingRetentionPeriodUnits | Gets or sets the unit type for a retention period value. |
![]() | CloseCursorsOnCommitEnabled | Gets or sets a value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active. |
![]() | Collation | Gets or sets the default collation used by the database. |
![]() | ColumnEncryptionKeys | Gets a collection of column encryption keys. |
![]() | ColumnMasterKeys | Gets or sets the Column MasterKeys. |
![]() | CompatibilityLevel | Gets or sets the compatibility level for the database. |
![]() | ConcatenateNullYieldsNull | Gets or sets a value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active. |
![]() | ContainmentType | Gets or sets the type of containment. |
![]() | CreateDate | Gets the date that the database was created. |
![]() | DatabaseAuditSpecifications | Gets a collection of DatabaseAuditSpecification objects. Each DatabaseAuditSpecification object represents a database audit specification defined on the server. |
![]() | DatabaseEncryptionKey | Gets a DataBaseEncryptionKey data type. |
![]() | DatabaseGuid | Gets the Guid value that uniquely identifies the database. |
![]() | DatabaseOptions | Gets the DatabaseOptions object that contains configuration options for the database. |
![]() | DatabaseOwnershipChaining | Gets or sets a value that specifies whether the database ownership chaining is active. |
![]() | DatabaseScopedCredentials | Gets the database scoped credential collection. |
![]() | DatabaseSnapshotBaseName | Gets the name of the snapshot base for the database. |
![]() | DataSpaceUsage | Gets the space used by the data in the database. |
![]() | DateCorrelationOptimization | Gets or sets a value that specifies whether the date correlation optimization is active. |
![]() | DboLogin | Gets a value that specifies whether the current user is logged on as the database owner (DBO). |
![]() | DefaultFileGroup | Gets the default file group used by the database. |
![]() | DefaultFileStreamFileGroup | Gets the file group name for the default file stream. |
![]() | DefaultFullTextCatalog | Gets the default full-text catalog used by the database. |
![]() | DefaultFullTextLanguage | Gets the default full text language. |
![]() | DefaultLanguage | Gets or sets the default language. |
![]() | Defaults | |
![]() | DefaultSchema | Gets the default schema of the user. |
![]() | DelayedDurability | Gets or sets the delayed durability setting of a database. |
![]() | EncryptionEnabled | Gets or sets a value that indicates whether the data encryption is enabled. |
![]() | Events | Gets the events associated with the database. |
![]() | ExecutionManager | Gets the execution manager.(Overrides SqlSmoObject.ExecutionManager.) |
![]() | ExtendedProperties | Gets the extended properties of the database. |
![]() | ExtendedStoredProcedures | Gets a collection of ExtendedStoredProcedure objects. Each ExtendedStoredProcedure object represents an extended stored procedure defined on the database. |
![]() | ExternalDataSources | Gets the collection of external data source. |
![]() | ExternalFileFormats | Gets a collection of external file formats. |
![]() | Federations | Gets a collection of Federation objects. Each Federation represents a data being partitioned on the database. |
![]() | FileGroups | |
![]() | FilestreamDirectoryName | Gets or sets the name of file stream share directory. |
![]() | FilestreamNonTransactedAccess | Gets or sets the file stream non-transacted access setting for database. |
![]() | FullTextCatalogs | Gets a collection of FullTextCatalog objects. Each FullTextCatalog object represents a full-text catalog defined on the database. |
![]() | FullTextStopLists | Gets a collection of FullTextStopList objects. Each FullTextStopList object represents a full text stop list defined on the server. |
![]() | HasFileInCloud | Gets a value that indicates whether the database has file in Cloud database. |
![]() | HasMemoryOptimizedObjects | Gets the Boolean value that specifies whether the database contains memory optimized objects. |
![]() | HonorBrokerPriority | Gets or sets a value that specifies whether the priority specified by the broker is acknowledged or not. |
![]() | ID | Gets the database ID value that uniquely identifies the database. |
![]() | IndexSpaceUsage | Gets the space used by the indexes in the database. |
![]() | IsAccessible | Gets a value that specifies whether the database can be accessed. |
![]() | IsDatabaseSnapshot | Gets a value that specifies whether the database is a snapshot database. |
![]() | IsDatabaseSnapshotBase | Gets a value that specifies whether the database is the base database for a snapshot database. |
![]() | IsDbAccessAdmin | Gets a value that specifies whether the current user is a member of the DbAccessAdmin database role. |
![]() | IsDbBackupOperator | Gets a value that specifies whether the current user is a member of the DbBackupOperator database role. |
![]() | IsDbDatareader | Gets a value that specifies whether the current user is a member of the DbDatareader database role. |
![]() | IsDbDatawriter | Gets a value that specifies whether the current user is a member of the DbDatawriter database role. |
![]() | IsDbDdlAdmin | Gets a value that specifies whether the current user is a member of the DbDdlAdmin database role. |
![]() | IsDbDenyDatareader | Gets a value that specifies whether the current user is a member of the DbDenyDatareader database role. |
![]() | IsDbDenyDatawriter | Gets a value that specifies whether the current member is a member of the DbDenyDatawriter database. |
![]() | IsDbManager | Gets a value that specifies whether the current login is a database manager in SQL Database. |
![]() | IsDbOwner | Gets a value that specifies whether the current user is a member of the DbOwner database role. |
![]() | IsDbSecurityAdmin | Gets a value that specifies whether the current user is a member of the DbSecurityAdmin database role. |
![]() | IsFederationMember | Gets or sets a value that specifies whether the database is a member of federation. |
![]() | IsFullTextEnabled | Gets or sets a value that specifies whether the database is enabled for full-text search. |
![]() | IsLoginManager | Gets a value that specifies whether the current login is a login manager in SQL Database. |
![]() | IsMailHost | Gets a value that specifies whether the database is configured as a mail host. |
![]() | IsManagementDataWarehouse | Gets a value that specifies whether the database is a management data warehouse. |
![]() | IsMirroringEnabled | Gets a value that specifies whether mirroring is enabled on the database. |
![]() | IsParameterizationForced | Gets or sets a value that specifies whether parameterization is forced on the database. |
![]() | IsReadCommittedSnapshotOn | Gets or sets a value that specifies whether transactions with the read committed isolation level use row versioning. |
![]() | IsSystemObject | Gets a value that specifies whether the database is a system object or a user-defined database. |
![]() | IsUpdateable | Gets a value that specifies whether the database can be updated. |
![]() | IsVarDecimalStorageFormatEnabled | Gets or sets a value that specifies whether VarDecimal storage is enabled. |
![]() | LastBackupDate | Gets the date and time when the database was last backed up. |
![]() | LastDifferentialBackupDate | Gets the date and time when the last differential backup was performed. |
![]() | LastLogBackupDate | Gets the date and time when the transaction log was last backed up. |
![]() | LocalCursorsDefault | Gets or sets a value that specifies whether the local server cursors are used by default. |
![]() | LogFiles | |
![]() | LogReuseWaitStatus | Gets the type of operation on which the reuse of transaction log space is waiting. |
![]() | MasterKey | Gets the master key that is used to encrypt the private keys of certificates. |
![]() | MemoryAllocatedToMemoryOptimizedObjectsInKB | Gets the memory (in kilobytes) allocated to memory-optimized objects in the database. |
![]() | MemoryUsedByMemoryOptimizedObjectsInKB | Gets the memory used (in kilobytes) by memory-optimized objects in the database. |
![]() | MirroringFailoverLogSequenceNumber | Gets the log sequence number at last failover. |
![]() | MirroringID | Gets the ID value that uniquely identifies the mirroring partnership. |
![]() | MirroringPartner | Gets or sets the address of the Database Engine instance that is the partner server for database mirroring. |
![]() | MirroringPartnerInstance | Gets the instance of SQL Server on which the mirroring partner is configured. |
![]() | MirroringRedoQueueMaxSize | Gets the maximum size of the redo queue of the mirror server instance in KB. |
![]() | MirroringRoleSequence | Gets the role sequence number for primary/backup roles played by the mirroring partners. |
![]() | MirroringSafetyLevel | Gets or sets the mirroring safety level. |
![]() | MirroringSafetySequence | Gets the role sequence number for safety levels for the mirroring partners. |
![]() | MirroringStatus | Gets the status of the database and the database mirroring session. |
![]() | MirroringTimeout | Gets or sets the maximum time, in seconds, that the principal server instance waits for a PING message from another instance in the mirroring session before assuming the other instance is disconnected. |
![]() | MirroringWitness | Gets or sets the name of the Database Engine instance of the database mirroring witness server. |
![]() | MirroringWitnessStatus | Gets the status of the mirroring witness server. |
![]() | Name | Gets or sets the name of the database.(Overrides NamedSmoObject.Name.) |
![]() | NestedTriggersEnabled | Gets or sets a value that indicates whether the nested triggers are enabled. |
![]() | NumericRoundAbortEnabled | Gets or sets a value that specifies whether the NUMERIC_ROUNDABORT database option is active. |
![]() | Owner | Gets the database principal that is the owner of the database. |
![]() | PageVerify | Gets or sets the type of page integrity check that SQL Server performs when reading database pages. |
![]() | Parent | |
![]() | PartitionFunctions | Gets a collection of PartitionFunction objects. Each PartitionFunction object represents a partition function defined on the database. |
![]() | PartitionSchemes | Gets a collection of PartitionScheme objects. Each PartitionScheme object represents a partition scheme defined on the database. |
![]() | PlanGuides | Gets a collection of plan guides associated with a database. |
![]() | PrimaryFilePath | Gets the operating system directory that contains the primary file for the database. |
![]() | Properties | Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.) |
![]() | QueryStoreOptions | Gets the options for the query store. |
![]() | QuotedIdentifiersEnabled | Gets or sets a value that specifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules. |
![]() | ReadOnly | Gets or sets a value that specifies whether the database is read-only. |
![]() | RecoveryForkGuid | Gets the GUID value that specifies the recovery fork on which the database is currently active. |
![]() | RecoveryModel | Gets or sets the recovery model for the database. |
![]() | RecursiveTriggersEnabled | Gets or sets a value that specifies whether recursive triggers are enabled on the database. |
![]() | RemoteDataArchiveCredential | Gets or sets the remote data archive. |
![]() | RemoteDataArchiveEnabled | Gets or sets a value that indicates whether remote data archive is enabled. |
![]() | RemoteDataArchiveEndpoint | Gets or sets the remote data archive endpoint for the database. |
![]() | RemoteDataArchiveLinkedServer | Gets or sets the remote data archive linked server for the database. |
![]() | RemoteDataArchiveUseFederatedServiceAccount | Gets or sets a value whether the RemoteDataArchive uses the FederatedServiceAccount. |
![]() | RemoteDatabaseName | Gets or sets the remote database name. |
![]() | ReplicationOptions | Gets the active replication settings for a database. |
![]() | Roles | Gets a collection of DatabaseRole objects. Each DatabaseRole object represents a role defined on the database. |
![]() | Rules | |
![]() | Schemas | |
![]() | SearchPropertyLists | Gets the SearchPropertyListCollection associated with this object. |
![]() | SecurityPolicies | Gets the Security Policies from the Database. |
![]() | Sequences | Gets the SequenceCollection associated with this object. |
![]() | ServiceBroker | Gets the ServiceBroker object that represents the Service Broker. |
![]() | ServiceBrokerGuid | Gets the Guid object that uniquely identifies the instance of Service Broker. |
![]() | Size | Gets the size of the database in MB. |
![]() | SnapshotIsolationState | Gets the snapshot isolation state for the database. |
![]() | SpaceAvailable | Gets the available space in the database in KB. |
![]() | State | Gets the state of the referenced object.(Inherited from SmoObjectBase.) |
![]() | Status | Gets the database status. |
![]() | StoredProcedures | Gets a collection of StoredProcedure objects. Each StoredProcedure object represents a stored procedure defined on the database. |
![]() | SymmetricKeys | Gets a collection of SymmetricKey objects. Each SymmetricKey object represents a symmetric key defined on the database. |
![]() | Synonyms | |
![]() | Tables | |
![]() | TargetRecoveryTime | Gets or sets the target recovery time of the used database. |
![]() | TransformNoiseWords | Gets a value that indicates whether an object that sets the transform noise words configuration option is used. |
![]() | Triggers | Gets a collection of DatabaseDdlTrigger objects. Each DatabaseDdlTrigger object represents a trigger defined on the database. |
![]() | Trustworthy | Gets or sets a value that indicates whether the instance of SQL Server 2005 trusts the database and the contents within it. |
![]() | TwoDigitYearCutoff | Gets or sets the specified object that is used to set the two digit year cutoff configuration option. |
![]() | Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.) |
![]() | UserAccess | Gets or sets the database user access. |
![]() | UserData | Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.) |
![]() | UserDefinedAggregates | Gets a collection of UserDefinedAggregate objects. Each UserDefinedAggregate object represents a user-defined aggregate defined on the database. |
![]() | UserDefinedDataTypes | Gets a collection of UserDefinedDataType objects. Each UserDefinedDataType object represents a user-defined data type on the database. |
![]() | UserDefinedFunctions | Gets a collection of UserDefinedFunction objects. Each UserDefinedFunction object represents a user-defined function on the database. |
![]() | UserDefinedTableTypes | Gets a collection of UserDefinedTableType objects. Each UserDefinedTableType object represents a user-defined table type on the database. |
![]() | UserDefinedTypes | Gets a collection of UserDefinedType objects. Each UserDefinedType object represents a user-defined type on the database. |
![]() | UserName | Gets the database user name. |
![]() | Users | |
![]() | Version | Gets the version of the instance of SQL Server that was used to create the database. |
![]() | Views | |
![]() | XmlSchemaCollections | Gets a collection of XmlSchemaCollection objects. Each XmlSchemaCollection object represents an XML schema defined on the database. |
Name | Description | |
---|---|---|
![]() ![]() | ISfcSupportsDesignMode.IsDesignMode | Gets a value that indicates whether the object supports design mode. |