.png)
Database Properties
SQL Server 2012
The Database type exposes the following members.
| 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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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 | Gets a collection of Default objects. Each Default object represents a default defined on the database. |
|
|
DefaultSchema | Gets the default schema of the user. |
|
|
EncryptionEnabled | Gets or sets a value that indicates whether the data encryption is enabled. |
|
|
Events | Gets the events associated with the database. |
|
|
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. |
|
|
Federations | Gets a collection of Federation objects. Each Federation represents a data being partitioned on the database. |
|
|
FileGroups | Gets a collection of FileGroup objects. Each FileGroup object represents a file group defined on the database. |
|
|
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. |
|
|
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 | Gets a collection of LogFile objects. Each LogFile object represents a log file defined on the database. |
|
|
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. |
|
|
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 | Gets or sets the Server object that is the parent of the Database object. |
|
|
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.) |
|
|
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. |
|
|
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 | Gets a collection of Rule objects. Each Rule object represents a rule defined on the database. |
|
|
Schemas | Gets a collection of Schema objects. Each Schema object represents a schema defined on the database. |
|
|
SearchPropertyLists | Gets the SearchPropertyListCollection associated with this object. |
|
|
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 | Gets a collection of Synonym objects. Each Synonym object represents a synonym defined on the database. |
|
|
Tables | Gets a collection of Table objects. Each Table object represents a table defined on the database. |
|
|
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 | Gets a collection of User objects. Each User object represents a user who is defined on the database. |
|
|
Version | Gets the version of the instance of SQL Server that was used to create the database. |
|
|
Views | Gets a collection of View objects. Each View object represents a view defined on the database. |
|
|
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. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
