Export (0) Print
Expand All
Expand Minimize

Database Properties

The Database type exposes the following members.

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

  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a value that indicates whether the object supports design mode. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft