Database Properties
SQL Server 2008 R2
The Database type exposes the following members.
| Name | Description | |
|---|---|---|
|
ActiveConnections | Gets the number of active connections to the database. |
|
|
ActiveDirectory | Gets the information about the Active Directory settings for the database. |
|
|
AnsiNullDefault | Gets or sets AnsiNullDefault Property. |
|
|
AnsiNullsEnabled | Gets or sets the Boolean ANSI_NULLS_ENABLED property value. |
|
|
AnsiPaddingEnabled | Gets or sets the ANSI_PADDING_ENABLED database option is enabled. |
|
|
AnsiWarningsEnabled | Gets or sets the Boolean ANSI_WARNING_ENABLED property value. |
|
|
ApplicationRoles | Represents a collection of ApplicationRole objects. Each ApplicationRole object represents an application role defined on the database. |
|
|
ArithmeticAbortEnabled | Gets or sets the ARITHMETICABORT property value. |
|
|
Assemblies | Represents a collection of SqlAssembly objects. Each SqlAssembly object represents an assembly defined on the database. |
|
|
AsymmetricKeys | Represents a collection of AsymmetricKey objects. Each AsymmetricKey object represents an asymmetric key defined on the database. |
|
|
AutoClose | Gets or sets the AUTOCLOSE database option is set. |
|
|
AutoCreateStatisticsEnabled | Gets a Boolean property value that specifies whether statistics are automatically created for the database. |
|
|
AutoShrink | Gets or sets the AUTO_SHRINK database option. |
|
|
AutoUpdateStatisticsAsync | Gets or sets a property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active. |
|
|
AutoUpdateStatisticsEnabled | Gets a Boolean property value that specifies whether statistics are automatically updated for the database. |
|
|
BrokerEnabled | Gets or sets a property value that specifies whether the Service Broker service is enabled. |
|
|
CaseSensitive | Gets a Boolean property value that specifies whether uppercase letters and lowercase letters are evaluated as equal. |
|
|
Certificates | Represents a collection of Certificate objects. Each Certificate object represents a certificate defined on the database. |
|
|
ChangeTrackingAutoCleanUp | Gets or sets a Boolean property value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled. |
|
|
ChangeTrackingEnabled | Gets or sets a property 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 property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active. |
|
|
CreateDate | Gets the date that the database was created. |
|
|
DatabaseAuditSpecifications | Represents a collection of DatabaseAuditSpecification objects. Each DatabaseAuditSpecification object represents an database audit specification defined on the server. |
|
|
DatabaseEncryptionKey | Gets a DataBaseEncryptionKey datatype. |
|
|
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 property 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 property value that specifies whether the date correlation optimization is active. For more information about date correlation optimization, see Setting Database Options. |
|
|
DboLogin | Gets the Boolean 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 a DefaultFileStreamFileGroup datatype |
|
|
DefaultFullTextCatalog | Gets the default full-text catalog used by the database. |
|
|
Defaults | Represents 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 the ENCRYPTIONENABLED property of a database. |
|
|
Events | Gets the events associated with the database. |
|
|
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Inherited from SqlSmoObject.) |
|
|
ExtendedProperties | Gets the extended properties of the database. |
|
|
ExtendedStoredProcedures | Represents a collection of ExtendedStoredProcedure objects. Each ExtendedStoredProcedure object represents an extended stored procedure defined on the database. |
|
|
FileGroups | Represents a collection of FileGroup objects. Each FileGroup object represents a filegroup defined on the database. |
|
|
FullTextCatalogs | Represents a collection of FullTextCatalog objects. Each FullTextCatalog object represents a full-text catalog defined on the database. |
|
|
FullTextStopLists | Represents a collection of FullTextStopList objects. Each FullTextStopList object represents a full text stop list defined on the server. |
|
|
HonorBrokerPriority | Gets or sets the Boolean 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 Boolean property value that specifies whether the database can be accessed. |
|
|
IsDatabaseSnapshot | Gets a Boolean property value that specifies whether the database is a snapshot database. |
|
|
IsDatabaseSnapshotBase | Gets a Boolean property value that specifies whether the database is the base database for a snapshot database. |
|
|
IsDbAccessAdmin | Gets a Boolean property value that specifies whether the current user is a member of the DbAccessAdmin database role. |
|
|
IsDbBackupOperator | Gets a Boolean property value that specifies whether the current user is a member of the DbBackupOperator database role. |
|
|
IsDbDatareader | Gets a Boolean property value that specifies whether the current user is a member of the DbDatareader database role. |
|
|
IsDbDatawriter | Gets a Boolean property value that specifies whether the current user is a member of the DbDatawriter database role. |
|
|
IsDbDdlAdmin | Gets a Boolean property value that specifies whether the current user is a member of the DbDdlAdmin database role. |
|
|
IsDbDenyDatareader | Gets a Boolean property value that specifies whether the current user is a member of the DbDenyDatareader database role. |
|
|
IsDbDenyDatawriter | Gets a Boolean property value that specifies whether the current member is a member of the DbDenyDatawriter database. |
|
|
IsDbManager | Gets a Boolean value that specifies whether the current login is a database manager in SQL Azure. |
|
|
IsDbOwner | Gets a Boolean property value that specifies whether the current user is a member of the DbOwner database role. |
|
|
IsDbSecurityAdmin | Gets a Boolean property value that specifies whether the current user is a member of the DbSecurityAdmin database role. |
|
|
IsFullTextEnabled | Gets the Boolean value that specifies whether the database is enabled for full-text search. |
|
|
IsLoginManager | Gets a Boolean value that specifies whether the current login is a login manager in SQL Azure. |
|
|
IsMailHost | Gets the Boolean value that specifies whether the database is configured as a mail host. |
|
|
IsManagementDataWarehouse | Gets the Boolean value that specifies whether the database is a management data warehouse. |
|
|
IsMirroringEnabled | Gets the Boolean value that specifies whether mirroring is enabled on the database. |
|
|
IsParameterizationForced | Gets or sets a property value that specifies whether parameterization is forced on the database. |
|
|
IsReadCommittedSnapshotOn | Gets the Boolean value that specifies whether transactions with the read committed isolation level use row versioning. |
|
|
IsSystemObject | Gets the Boolean value that specifies whether the database is a system object or a user-defined database. |
|
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Inherited from SqlSmoObject.) |
|
|
IsUpdateable | Gets the Boolean value that specifies whether the database can be updated. |
|
|
IsVarDecimalStorageFormatEnabled | Gets or sets a property 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 the Boolean value that specifies whether the local server cursors are used by default. |
|
|
LogFiles | Represents 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 or sets 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.) |
|
|
NumericRoundAbortEnabled | Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active. |
|
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Inherited from SqlSmoObject.) |
|
|
Owner | Gets the database principal that is the owner of the database. |
|
|
PageVerify | Specifies the type of page integrity check that SQL Server performs when reading database pages. |
|
|
Parent | Gets the Server object that is the parent of the Database object. |
|
|
PartitionFunctions | Represents a collection of PartitionFunction objects. Each PartitionFunction object represents a partition function defined on the database. |
|
|
PartitionSchemes | Represents a collection of PartitionScheme objects. Each PartitionScheme object represents a partition scheme defined on the database. |
|
|
PlanGuides | Gets 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 Boolean property 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 the Boolean property 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 the Boolean value that specifies whether recursive triggers are enabled on the database. |
|
|
ReplicationOptions | Gets the active replication settings for a database, |
|
|
Roles | Represents a collection of DatabaseRole objects. Each DatabaseRole object represents a role defined on the database. |
|
|
Rules | Represents a collection of Rule objects. Each Rule object represents a rule defined on the database. |
|
|
ScalarResult | Gets the scalar result for the referenced object. (Inherited from SqlSmoObject.) |
|
|
Schemas | Represents a collection of Schema objects. Each Schema object represents a schema defined on the database. |
|
|
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 | Represents a collection of StoredProcedure objects. Each StoredProcedure object represents a stored procedure defined on the database. |
|
|
SymmetricKeys | Represents a collection of SymmetricKey objects. Each SymmetricKey object represents a symmetric key defined on the database. |
|
|
Synonyms | Represents a collection of Synonym objects. Each Synonym object represents a synonym defined on the database. |
|
|
Tables | Represents a collection of Table objects. Each Table object represents a table defined on the database. |
|
|
Triggers | Represents a collection of DatabaseDdlTrigger objects. Each DatabaseDdlTrigger object represents a trigger defined on the database. |
|
|
Trustworthy | The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server 2005 trusts the database and the contents within it |
|
|
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 | Represents a collection of UserDefinedAggregate objects. Each UserDefinedAggregate object represents a user-defined aggregate defined on the database. |
|
|
UserDefinedDataTypes | Represents a collection of UserDefinedDataType objects. Each UserDefinedDataType object represents a user-defined data type on the database. |
|
|
UserDefinedFunctions | Represents a collection of UserDefinedFunction objects. Each UserDefinedFunction object represents a user-defined function on the database. |
|
|
UserDefinedTableTypes | Represents a collection of UserDefinedTableType objects. Each UserDefinedTableType object represents a user-defined table type on the database. |
|
|
UserDefinedTypes | Represents a collection of UserDefinedType objects. Each UserDefinedType object represents a user-defined type on the database. |
|
|
UserName | Gets or sets the database user name. |
|
|
Users | Represents 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 | Represents a collection of View objects. Each View object represents a view defined on the database. |
|
|
XmlSchemaCollections | Represents a collection of XmlSchemaCollection objects. Each XmlSchemaCollection object represents an XML schema defined on the database. |
| Name | Description | |
|---|---|---|
|
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that indicates whether the object supports design mode. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
