Database Properties
Include Protected Members
Include Inherited Members
The Database type exposes the following members.
Properties
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. | |
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. | |
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. | |
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 object. (Inherited from NamedSmoObject.) | |
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 path and name of 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. |
Top