Database Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Information about a single database
public class Database
type Database = class
Public Class Database
- Inheritance
-
Database
Constructors
Database() |
Initializes a new instance of the Database class. |
Database(String, String, String, String, String, String, String, String, String, String, String, String, String, Nullable<Int32>, Nullable<Int32>, String, String) |
Initializes a new instance of the Database class. |
Properties
Collation |
Gets or sets collation name of the database |
CompatibilityLevel |
Gets or sets sQL Server compatibility level of database Possible values include: 'CompatLevel80', 'CompatLevel90', 'CompatLevel100', 'CompatLevel110', 'CompatLevel120', 'CompatLevel130', 'CompatLevel140' |
DatabaseState |
Gets or sets state of the database Possible values include: 'Online', 'Restoring', 'Recovering', 'RecoveryPending', 'Suspect', 'Emergency', 'Offline', 'Copying', 'OfflineSecondary' |
Fqdn |
Gets or sets fully qualified name |
Id |
Gets or sets unique identifier for the database |
InstallId |
Gets or sets install id of the database |
Name |
Gets or sets name of the database |
ServerCoreCount |
Gets or sets number of cores on the server |
ServerDefaultBackupPath |
Gets or sets default path of the backup folder |
ServerDefaultDataPath |
Gets or sets default path of the data files |
ServerDefaultLogPath |
Gets or sets default path of the log files |
ServerEdition |
Gets or sets edition of the server |
ServerId |
Gets or sets the unique Server Id |
ServerLevel |
Gets or sets product level of the server (RTM, SP, CTP). |
ServerName |
Gets or sets name of the server |
ServerVersion |
Gets or sets version of the server |
ServerVisibleOnlineCoreCount |
Gets or sets number of cores on the server that have VISIBLE ONLINE status |