Database Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyActiveConnections

Gets the number of active connections to the database.

System_CAPS_pubpropertyActiveDirectory

Obsolete.Gets the information about the Active Directory settings for the database.

System_CAPS_pubpropertyAnsiNullDefault

Gets or sets a value that specifies whether the ANSI_NULL_DEFAULT database option is active.

System_CAPS_pubpropertyAnsiNullsEnabled

Gets or sets a value that specifies whether the ANSI_NULLS_ENABLED database option is active.

System_CAPS_pubpropertyAnsiPaddingEnabled

Gets or sets a value that specifies whether the ANSI_PADDING_ENABLED database option is active.

System_CAPS_pubpropertyAnsiWarningsEnabled

Gets or sets a value that specifies whether the ANSI_WARNINGS_ENABLED database option is active.

System_CAPS_pubpropertyApplicationRoles

Gets a collection of ApplicationRole objects. Each ApplicationRole object represents an application role defined on the database.

System_CAPS_pubpropertyArithmeticAbortEnabled

Gets or sets a value that specifies whether the ARITHMETICABORT database option is active.

System_CAPS_pubpropertyAssemblies

Gets a collection of SqlAssembly objects. Each SqlAssembly object represents an assembly defined on the database.

System_CAPS_pubpropertyAsymmetricKeys

Gets a collection of AsymmetricKey objects. Each AsymmetricKey object represents an asymmetric key defined on the database.

System_CAPS_pubpropertyAutoClose

Gets or sets a value that specifies whether the AUTOCLOSE database option is set.

System_CAPS_pubpropertyAutoCreateIncrementalStatisticsEnabled

Gets a value that specifies whether the incremental statistics are automatically created for the database.

System_CAPS_pubpropertyAutoCreateStatisticsEnabled

Gets a value that specifies whether statistics are automatically created for the database.

System_CAPS_pubpropertyAutoShrink

Gets or sets a value that specifies whether the AUTO_SHRINK database option is active.

System_CAPS_pubpropertyAutoUpdateStatisticsAsync

Gets or sets a value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active.

System_CAPS_pubpropertyAutoUpdateStatisticsEnabled

Gets or sets a value that specifies whether statistics are automatically updated for the database.

System_CAPS_pubpropertyAvailabilityDatabaseSynchronizationState

Gets the synchronization state of the availability database.

System_CAPS_pubpropertyAvailabilityGroupName

Gets the availability group name in the database.

System_CAPS_pubpropertyAzureEdition

System_CAPS_pubpropertyAzureServiceObjective

System_CAPS_pubpropertyBrokerEnabled

Gets or sets a value that specifies whether the Service Broker service is enabled.

System_CAPS_pubpropertyCaseSensitive

Gets a value that specifies whether uppercase letters and lowercase letters are evaluated as equal.

System_CAPS_pubpropertyCertificates

Gets a collection of Certificate objects. Each Certificate object represents a certificate defined on the database.

System_CAPS_pubpropertyChangeTrackingAutoCleanUp

Gets or sets a value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled.

System_CAPS_pubpropertyChangeTrackingEnabled

Gets or sets a value that specifies whether the CHANGE_TRACKING_VALUE option is enabled.

System_CAPS_pubpropertyChangeTrackingRetentionPeriod

Gets or sets the CHANGE_TRACKING_RETENTION_PERIOD value.

System_CAPS_pubpropertyChangeTrackingRetentionPeriodUnits

Gets or sets the unit type for a retention period value.

System_CAPS_pubpropertyCloseCursorsOnCommitEnabled

Gets or sets a value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.

System_CAPS_pubpropertyCollation

Gets or sets the default collation used by the database.

System_CAPS_pubpropertyColumnEncryptionKeys

System_CAPS_pubpropertyColumnMasterKeys

System_CAPS_pubpropertyCompatibilityLevel

Gets or sets the compatibility level for the database.

System_CAPS_pubpropertyConcatenateNullYieldsNull

Gets or sets a value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.

System_CAPS_pubpropertyContainmentType

Gets or sets the type of containment.

System_CAPS_pubpropertyCreateDate

Gets the date that the database was created.

System_CAPS_pubpropertyDatabaseAuditSpecifications

Gets a collection of DatabaseAuditSpecification objects. Each DatabaseAuditSpecification object represents a database audit specification defined on the server.

System_CAPS_pubpropertyDatabaseEncryptionKey

Gets a DataBaseEncryptionKey data type.

System_CAPS_pubpropertyDatabaseGuid

Gets the Guid value that uniquely identifies the database.

System_CAPS_pubpropertyDatabaseOptions

Gets the DatabaseOptions object that contains configuration options for the database.

System_CAPS_pubpropertyDatabaseOwnershipChaining

Gets or sets a value that specifies whether the database ownership chaining is active.

System_CAPS_pubpropertyDatabaseScopedCredentials

System_CAPS_pubpropertyDatabaseSnapshotBaseName

Gets the name of the snapshot base for the database.

System_CAPS_pubpropertyDataSpaceUsage

Gets the space used by the data in the database.

System_CAPS_pubpropertyDateCorrelationOptimization

Gets or sets a value that specifies whether the date correlation optimization is active.

System_CAPS_pubpropertyDboLogin

Gets a value that specifies whether the current user is logged on as the database owner (DBO).

System_CAPS_pubpropertyDefaultFileGroup

Gets the default file group used by the database.

System_CAPS_pubpropertyDefaultFileStreamFileGroup

Gets the file group name for the default file stream.

System_CAPS_pubpropertyDefaultFullTextCatalog

Gets the default full-text catalog used by the database.

System_CAPS_pubpropertyDefaultFullTextLanguage

Gets the default full text language.

System_CAPS_pubpropertyDefaultLanguage

Gets or sets the default language.

System_CAPS_pubpropertyDefaults

Gets a collection of Default objects. Each Default object represents a default defined on the database.

System_CAPS_pubpropertyDefaultSchema

Gets the default schema of the user.

System_CAPS_pubpropertyDelayedDurability

Gets or sets the delayed durability setting of a database.

System_CAPS_pubpropertyEncryptionEnabled

Gets or sets a value that indicates whether the data encryption is enabled.

System_CAPS_pubpropertyEvents

Gets the events associated with the database.

System_CAPS_pubpropertyExecutionManager
System_CAPS_pubpropertyExtendedProperties

Gets the extended properties of the database.

System_CAPS_pubpropertyExtendedStoredProcedures

Gets a collection of ExtendedStoredProcedure objects. Each ExtendedStoredProcedure object represents an extended stored procedure defined on the database.

System_CAPS_pubpropertyExternalDataSources

System_CAPS_pubpropertyExternalFileFormats

System_CAPS_pubpropertyFederations

Gets a collection of Federation objects. Each Federation represents a data being partitioned on the database.

System_CAPS_pubpropertyFileGroups

Gets a collection of FileGroup objects. Each FileGroup object represents a file group defined on the database.

System_CAPS_pubpropertyFilestreamDirectoryName

Gets or sets the name of file stream share directory.

System_CAPS_pubpropertyFilestreamNonTransactedAccess

Gets or sets the file stream non-transacted access setting for database.

System_CAPS_pubpropertyFullTextCatalogs

Gets a collection of FullTextCatalog objects. Each FullTextCatalog object represents a full-text catalog defined on the database.

System_CAPS_pubpropertyFullTextStopLists

Gets a collection of FullTextStopList objects. Each FullTextStopList object represents a full text stop list defined on the server.

System_CAPS_pubpropertyHasFileInCloud

Gets a value that indicates whether the database has file in Cloud database.

System_CAPS_pubpropertyHasMemoryOptimizedObjects

Gets the Boolean value that specifies whether the database contains memory optimized objects.

System_CAPS_pubpropertyHonorBrokerPriority

Gets or sets a value that specifies whether the priority specified by the broker is acknowledged or not.

System_CAPS_pubpropertyID

Gets the database ID value that uniquely identifies the database.

System_CAPS_pubpropertyIndexSpaceUsage

Gets the space used by the indexes in the database.

System_CAPS_pubpropertyIsAccessible

Gets a value that specifies whether the database can be accessed.

System_CAPS_pubpropertyIsDatabaseSnapshot

Gets a value that specifies whether the database is a snapshot database.

System_CAPS_pubpropertyIsDatabaseSnapshotBase

Gets a value that specifies whether the database is the base database for a snapshot database.

System_CAPS_pubpropertyIsDbAccessAdmin

Gets a value that specifies whether the current user is a member of the DbAccessAdmin database role.

System_CAPS_pubpropertyIsDbBackupOperator

Gets a value that specifies whether the current user is a member of the DbBackupOperator database role.

System_CAPS_pubpropertyIsDbDatareader

Gets a value that specifies whether the current user is a member of the DbDatareader database role.

System_CAPS_pubpropertyIsDbDatawriter

Gets a value that specifies whether the current user is a member of the DbDatawriter database role.

System_CAPS_pubpropertyIsDbDdlAdmin

Gets a value that specifies whether the current user is a member of the DbDdlAdmin database role.

System_CAPS_pubpropertyIsDbDenyDatareader

Gets a value that specifies whether the current user is a member of the DbDenyDatareader database role.

System_CAPS_pubpropertyIsDbDenyDatawriter

Gets a value that specifies whether the current member is a member of the DbDenyDatawriter database.

System_CAPS_pubpropertyIsDbManager

Gets a value that specifies whether the current login is a database manager in SQL Database.

System_CAPS_pubpropertyIsDbOwner

Gets a value that specifies whether the current user is a member of the DbOwner database role.

System_CAPS_pubpropertyIsDbSecurityAdmin

Gets a value that specifies whether the current user is a member of the DbSecurityAdmin database role.

System_CAPS_pubpropertyIsFederationMember

Gets or sets a value that specifies whether the database is a member of federation.

System_CAPS_pubpropertyIsFullTextEnabled

Gets or sets a value that specifies whether the database is enabled for full-text search.

System_CAPS_pubpropertyIsLoginManager

Gets a value that specifies whether the current login is a login manager in SQL Database.

System_CAPS_pubpropertyIsMailHost

Gets a value that specifies whether the database is configured as a mail host.

System_CAPS_pubpropertyIsManagementDataWarehouse

Gets a value that specifies whether the database is a management data warehouse.

System_CAPS_pubpropertyIsMirroringEnabled

Gets a value that specifies whether mirroring is enabled on the database.

System_CAPS_pubpropertyIsParameterizationForced

Gets or sets a value that specifies whether parameterization is forced on the database.

System_CAPS_pubpropertyIsReadCommittedSnapshotOn

Gets or sets a value that specifies whether transactions with the read committed isolation level use row versioning.

System_CAPS_pubpropertyIsSystemObject

Gets a value that specifies whether the database is a system object or a user-defined database.

System_CAPS_pubpropertyIsUpdateable

Gets a value that specifies whether the database can be updated.

System_CAPS_pubpropertyIsVarDecimalStorageFormatEnabled

Gets or sets a value that specifies whether VarDecimal storage is enabled.

System_CAPS_pubpropertyLastBackupDate

Gets the date and time when the database was last backed up.

System_CAPS_pubpropertyLastDifferentialBackupDate

Gets the date and time when the last differential backup was performed.

System_CAPS_pubpropertyLastLogBackupDate

Gets the date and time when the transaction log was last backed up.

System_CAPS_pubpropertyLocalCursorsDefault

Gets or sets a value that specifies whether the local server cursors are used by default.

System_CAPS_pubpropertyLogFiles

Gets a collection of LogFile objects. Each LogFile object represents a log file defined on the database.

System_CAPS_pubpropertyLogReuseWaitStatus

Gets the type of operation on which the reuse of transaction log space is waiting.

System_CAPS_pubpropertyMasterKey

Gets the master key that is used to encrypt the private keys of certificates.

System_CAPS_pubpropertyMemoryAllocatedToMemoryOptimizedObjectsInKB

Gets the memory (in kilobytes) allocated to memory-optimized objects in the database.

System_CAPS_pubpropertyMemoryUsedByMemoryOptimizedObjectsInKB

Gets the memory used (in kilobytes) by memory-optimized objects in the database.

System_CAPS_pubpropertyMirroringFailoverLogSequenceNumber

Gets the log sequence number at last failover.

System_CAPS_pubpropertyMirroringID

Gets the ID value that uniquely identifies the mirroring partnership.

System_CAPS_pubpropertyMirroringPartner

Gets or sets the address of the Database Engine instance that is the partner server for database mirroring.

System_CAPS_pubpropertyMirroringPartnerInstance

Gets the instance of SQL Server on which the mirroring partner is configured.

System_CAPS_pubpropertyMirroringRedoQueueMaxSize

Gets the maximum size of the redo queue of the mirror server instance in KB.

System_CAPS_pubpropertyMirroringRoleSequence

Gets the role sequence number for primary/backup roles played by the mirroring partners.

System_CAPS_pubpropertyMirroringSafetyLevel

Gets or sets the mirroring safety level.

System_CAPS_pubpropertyMirroringSafetySequence

Gets the role sequence number for safety levels for the mirroring partners.

System_CAPS_pubpropertyMirroringStatus

Gets the status of the database and the database mirroring session.

System_CAPS_pubpropertyMirroringTimeout

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.

System_CAPS_pubpropertyMirroringWitness

Gets or sets the name of the Database Engine instance of the database mirroring witness server.

System_CAPS_pubpropertyMirroringWitnessStatus

Gets the status of the mirroring witness server.

System_CAPS_pubpropertyName

Gets or sets the name of the database.(Overrides NamedSmoObject.Name.)

System_CAPS_pubpropertyNestedTriggersEnabled

Gets or sets a value that indicates whether the nested triggers are enabled.

System_CAPS_pubpropertyNumericRoundAbortEnabled

Gets or sets a value that specifies whether the NUMERIC_ROUNDABORT database option is active.

System_CAPS_pubpropertyOwner

Gets the database principal that is the owner of the database.

System_CAPS_pubpropertyPageVerify

Gets or sets the type of page integrity check that SQL Server performs when reading database pages.

System_CAPS_pubpropertyParent

Gets or sets the Server object that is the parent of the Database object.

System_CAPS_pubpropertyPartitionFunctions

Gets a collection of PartitionFunction objects. Each PartitionFunction object represents a partition function defined on the database.

System_CAPS_pubpropertyPartitionSchemes

Gets a collection of PartitionScheme objects. Each PartitionScheme object represents a partition scheme defined on the database.

System_CAPS_pubpropertyPlanGuides

Gets a collection of plan guides associated with a database.

System_CAPS_pubpropertyPrimaryFilePath

Gets the operating system directory that contains the primary file for the database.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyQueryStoreOptions

System_CAPS_pubpropertyQuotedIdentifiersEnabled

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.

System_CAPS_pubpropertyReadOnly

Gets or sets a value that specifies whether the database is read-only.

System_CAPS_pubpropertyRecoveryForkGuid

Gets the GUID value that specifies the recovery fork on which the database is currently active.

System_CAPS_pubpropertyRecoveryModel

Gets or sets the recovery model for the database.

System_CAPS_pubpropertyRecursiveTriggersEnabled

Gets or sets a value that specifies whether recursive triggers are enabled on the database.

System_CAPS_pubpropertyRemoteDataArchiveCredential

System_CAPS_pubpropertyRemoteDataArchiveEnabled

System_CAPS_pubpropertyRemoteDataArchiveEndpoint

System_CAPS_pubpropertyRemoteDataArchiveLinkedServer

System_CAPS_pubpropertyRemoteDataArchiveUseFederatedServiceAccount

System_CAPS_pubpropertyRemoteDatabaseName

System_CAPS_pubpropertyReplicationOptions

Gets the active replication settings for a database.

System_CAPS_pubpropertyRoles

Gets a collection of DatabaseRole objects. Each DatabaseRole object represents a role defined on the database.

System_CAPS_pubpropertyRules

Gets a collection of Rule objects. Each Rule object represents a rule defined on the database.

System_CAPS_pubpropertySchemas

Gets a collection of Schema objects. Each Schema object represents a schema defined on the database.

System_CAPS_pubpropertySearchPropertyLists

Gets the SearchPropertyListCollection associated with this object.

System_CAPS_pubpropertySecurityPolicies

System_CAPS_pubpropertySequences

Gets the SequenceCollection associated with this object.

System_CAPS_pubpropertyServiceBroker

Gets the ServiceBroker object that represents the Service Broker.

System_CAPS_pubpropertyServiceBrokerGuid

Gets the Guid object that uniquely identifies the instance of Service Broker.

System_CAPS_pubpropertySize

Gets the size of the database in MB.

System_CAPS_pubpropertySnapshotIsolationState

Gets the snapshot isolation state for the database.

System_CAPS_pubpropertySpaceAvailable

Gets the available space in the database in KB.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyStatus

Gets the database status.

System_CAPS_pubpropertyStoredProcedures

Gets a collection of StoredProcedure objects. Each StoredProcedure object represents a stored procedure defined on the database.

System_CAPS_pubpropertySymmetricKeys

Gets a collection of SymmetricKey objects. Each SymmetricKey object represents a symmetric key defined on the database.

System_CAPS_pubpropertySynonyms

Gets a collection of Synonym objects. Each Synonym object represents a synonym defined on the database.

System_CAPS_pubpropertyTables

Gets a collection of Table objects. Each Table object represents a table defined on the database.

System_CAPS_pubpropertyTargetRecoveryTime

Gets or sets the target recovery time of the used database.

System_CAPS_pubpropertyTransformNoiseWords

Gets a value that indicates whether an object that sets the transform noise words configuration option is used.

System_CAPS_pubpropertyTriggers

Gets a collection of DatabaseDdlTrigger objects. Each DatabaseDdlTrigger object represents a trigger defined on the database.

System_CAPS_pubpropertyTrustworthy

Gets or sets a value that indicates whether the instance of SQL Server 2005 trusts the database and the contents within it.

System_CAPS_pubpropertyTwoDigitYearCutoff

Gets or sets the specified object that is used to set the two digit year cutoff configuration option.

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserAccess

Gets or sets the database user access.

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyUserDefinedAggregates

Gets a collection of UserDefinedAggregate objects. Each UserDefinedAggregate object represents a user-defined aggregate defined on the database.

System_CAPS_pubpropertyUserDefinedDataTypes

Gets a collection of UserDefinedDataType objects. Each UserDefinedDataType object represents a user-defined data type on the database.

System_CAPS_pubpropertyUserDefinedFunctions

Gets a collection of UserDefinedFunction objects. Each UserDefinedFunction object represents a user-defined function on the database.

System_CAPS_pubpropertyUserDefinedTableTypes

Gets a collection of UserDefinedTableType objects. Each UserDefinedTableType object represents a user-defined table type on the database.

System_CAPS_pubpropertyUserDefinedTypes

Gets a collection of UserDefinedType objects. Each UserDefinedType object represents a user-defined type on the database.

System_CAPS_pubpropertyUserName

Gets the database user name.

System_CAPS_pubpropertyUsers

Gets a collection of User objects. Each User object represents a user who is defined on the database.

System_CAPS_pubpropertyVersion

Gets the version of the instance of SQL Server that was used to create the database.

System_CAPS_pubpropertyViews

Gets a collection of View objects. Each View object represents a view defined on the database.

System_CAPS_pubpropertyXmlSchemaCollections

Gets a collection of XmlSchemaCollection objects. Each XmlSchemaCollection object represents an XML schema defined on the database.

Return to top
Show: