Database Class

Constructs a new Database object to be created with the given edition

Regular SMO objects access the parent class reference through parentColl (corresponding collection in parent class). Singleton class has no collection in parent.

Gets or sets the MD Catalog Collation type. Only valid during creation, and we cannot specify ContainedDatabaseCollation explicitly

DatabaseAuditSpecification Collection

Gets or sets the default fulltext language of this database.

Gets or sets the default language for the users of this database.

Whether the object has been touched for unconditional scripting of Alter

Whether vardecimal compression is enabled

Whether vardecimal compression is supported on the server

Get or set the Legacy_Cardinality_Estimation of the database scoped configuration.

Get or set the Legacy_Cardinality_Estimation for secondary of the database scoped configuration.

Gets or sets the MaxDop of the database scoped configuration.

Get or set the MaxDop for secondary of the database scoped configuration special accounting for nulls.

Get or set the Parameter_Sniffing of the database scoped configuration.

Get or set the Parameter_Sniffing for secondary of the database scoped configuration.

Returns the collection that contains the object. May be null.

Get or set the Query_Optimizer_Hotfixes of the database scoped configuration.

Get or set the Query_Optimizer_Hotfixes for secondary of the database scoped configuration.

Returns the ServerVersion of the Server that contains the object. If the object is not associated with a connected Server, the highest known server version is returned.

Returns the state of the object

Returns the Urn of the object, computed on the fly

Returns the name of the type in the urn expression

Renaming a database should ask for confirmation

method get called from the create script related method (from derived classes like Table, Index etc..)

Alters the database mirroring status

CheckAllocations

Wrapper for DBCC CHECKALLOC NOINDEX

Wrapper for DBCC CHECKCATALOG

If there are some properties which are respected in special cases then use this function. currently applicable for DatabaseDdltriggers

This is a virtual function, so that derived classes can override it if they want to do additional checks on the state of the object

Checks object state Because it is not recusrive, this function can be called directly and which means derived classes can't supply their own validation

Performs the CHECKPOINT command against the current database

Invokes DBCC CHECKDB with the given repair type and NO_INFOMSGS

Invokes DBCC CHECKDB with the given repair type and repair options

Invokes DBCC CHECKDB with the given options

Invokes DBCC CHECKDB with the given repair type and repair structure

Invokes DBCC CHECKDB with the NOINDEX option

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair options

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair options and repair structure.

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair structure

checks text syntax, that it manipulates the right type of object ( PROC, TRIGGER, etc )

checks text syntax, that it manipulates the right type of object ( PROC, TRIGGER, etc )

Creates the database on the instance of SQL Server.

Creates the database on the instance of SQL Server

DISABLE all the planguides

Best Effort Discovery mechanism : This method reflects upon metadata and gets all available objects

Drops the database

DROP all the planguides

Deletes the entries in the backup and restore history tables for database

Drops the object with IF EXISTS option. If object is invalid for drop function will return without exception.

drops the object

For drop calls on the user database in Azure, the connection will be closed as the database is dropped The ExecutionManager will normally attempt to retry such calls by reopening the connection We want to avoid this retry when handleSevereError is true.

drops the object

ENABLE all the planguides

Enables or disables encryption

Returns information about all backup set files for the database

Returns information about the files included in the given backup set

Returns information about all the backup sets for the database

The EnumCandidateKeys method returns a QueryResults object that enumerates the user tables of a Microsoft® SQL Server™ 2000 database and the constraints on those tables that could define primary keys.

EnumLocks

EnumLocks

EnumLoginMappings

The EnumMatchingSPs method returns a QueryResults object that enumerates the stored procedures that contain the specified search text

The EnumMatchingSPs method returns a QueryResults object that enumerates the stored procedures that contain the specified search text

The ListObjects method returns a SQLObjectList object that enumerates the system and user-defined objects defining the database referenced.

Returns a set of active transactions

Returns a set of active transactions

EnumWindowsGroups

EnumWindowsGroups

Executes sql statements

Creates the Rename query for a SqlSmoObject and Executes it on the Server.

Executes the given action under the given execution modes.

Resets the original modes after the action completes or fails.

Provides an enumerable of properties that are explicitly disabled for specific server types or editions. This is not a list of all properties that don't work for the specified target.

Retrieve the property value from : - The property bag directly if property is available (dirty or retrieved) - A call to our OnPropertyMissing method otherwise

Will throw an exception if the property value is NULL in either case.

Retrieve the property value from : - The property bag if the state is creating or we're in Design Mode (possible NULL value) - A call to our OnPropertyMissing method otherwise (will throw exception if value is NULL)

Returns the value of the named property. If the object is in the Creating state and the property has not yet been set the defaultValue is returned. If the object exists the defaultValue is ignored and the actual value is returned.

Retrieve the property value from : - The property bag if the state is creating or we're in Design Mode (possible NULL) - A call to our OnPropertyMissing method otherwise (possible NULL)

Returns the real value for the property.

Gets a list of remote data archive migration status reports

Get remote database migration statistics. Null if Remote Data Archive is not enabled for database

Gets the sqlserver public name for the current connection, e.g: will transfer "SQLTOOLS2008-2" to "SQL Server 2008".

Returns the comparer used by all child object collections to perform comparison of object names. The comparer of a Server is based on the collation of master The comparer of a Database and its children is based on the database collation

get the text of the object, if not available, throw apropiate exception based on the State of the object

Returns the number of open transactions

Returns the number of open transactions with

Computes the Urn for the object.

Computes the Urn for the object, potentially including other fields in the definition besides the key fields.

Initializes the child object collection associated with the given type. For example, the name Column would initialize the Columns collection.

Populate the FileGroup collection and each Files collection in each FileGroup optimally.

Initializes the object, by reading its properties from the enumerator

Clears Tables collection and initializes it with tables that have classified columns. The caller can always restore Tables collection by calling: db.Tables.ClearAndInitialize()

Populate the Tables collection and each Columns collection in each Table optimally

Returns whether the server containing this object is an Express SKU

Returns true if the database is part of an Availability Group and resides on the primary replica server

Determines if the current user is a member of the given group or role in the current database

Validate whether the specified property is supported in current server environment

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after altering the object

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after object creation

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after dropping the object

Initializes all the objects in the database

Initializes all the objects of type t and their children

Initializes all the objects of type t and their children needed to script with so

Reauthorize a stretched database with the SQL Azure server after the database is restored from a backup

refreshes the object's properties by reading them from the server

change object name

Returns a StringCollection object with the script for the object. This method throws an error if ScriptData is true

Set the accessToken for connection.

Sets the named file group as the default file group for the database.

Sets the named file group as the default file group for the database. It works for any file group, not just filestream

Sets the owner of this database to the login with the specified name. Does not drop any existing user accounts mapped to the login before attempting to change the owner.

Sets the owner of this database to the login with the specified name.

Enables or disables snapshot isolation for the current database

Sets the object state (Existing, Dropped etc.) Applications should avoid using this method.

Shrinks a database

Throws an exception if the ServerVersion major version for this object is above 10.0 (SQL 2008)

Throws an exception if the ServerVersion major version for this object is above 8.0 (SQL 2000)

Throws an exception if the ServerVersion major version for this object is below 10.0 (SQL 2008)

Throws an UnsupportedVersionException if either the source or destination server is below 11.0 (SQL 2012)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 11.0 (SQL 2012)

Throws an exception if the ServerVersion major version for this object is below 12.0 (SQL 2014)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 12.0 (SQL 2014)

Throws an exception if the ServerVersion major version for this object is below 13.0 (SQL 2016)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 13.0 (SQL 2016)

Throws an exception if the ServerVersion major version for this object is below 14.0 (SQL 2017)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 14.0 (SQL 2017)

Throws an exception if the ServerVersion major version for this object is below 8.0 (SQL 2000)

Throws an exception if the ServerVersion for this object is below 8.760 (8.0 SP3)

Throws an exception if the ServerVersion major version for this object is below 9.0 (SQL 2005)

Mark the object "touched" for unconditional scripting of Alter.

Virtual method to allow derived classes to do additional work when touched.

Truncate log. This is supported in SQL Server 2005 for backwards compatibility reasons.

Update statistics for all indexes in the database.

Validate all the planguides

Validate all the planguides

Discovers type of property.

Retrieves value for a given property. Throws if property is not found.

Sets state of this object based on provided SfcObjectState.

Sets the value of given property, if it is writable. If property is not in property bag, reflection is used. Throws exception if the property is not found.

This object extend ISfcSupportsDesignMode.

Finds all available checks for given database.

Finds all available checks for given smoObject.

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues.

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues.

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

Asynchronously runs assessment for given database and gives a List<T> describing discovered issues.

Asynchronously runs assessment for given smoObject and gives a List<T> describing discovered issues. This method performs only given checks from checks.

Asynchronously runs assessment for given smoObject and gives a List<T> describing discovered issues.

Checks if the specified type is supported by the ServerVersion and DatabaseEngineType of the root server for this object. If ScriptingPreferences are non-null will also check if specified type is supported by the ServerVersion and DatabaseEngineType of the target server.