Share via


SqlDatabase (Object)

 

Applies To: Windows Azure Pack

Represents a SQL Server database.

Elements

The SqlDatabase object has the following elements

Name

Description

Name

The name of the database.

SqlServerName

The name of the SQL server.

SqlServerId

The identifier of the SQL Server.

SubscriptionId

The identifier of the subscription.

ConnectionString

The connection string.

Edition

The edition.

BaseSizeMB

The database size in MB.

MaxSizeMB

The maximum database size in MB.

Collation

The database collation.

IsContained

true if the database instance is contained, otherwise false.

CreationDate

The date the database was created, in DateTime format.

Status

The database status. Possible values are:

Value

Description

0

The database is being created.

1

The database is created.

2

The database is being deleted.

3

The database is deleted.

4

The database is being updated.

5

The database is out of sync.

6

The database is partially created.

7

The database is partially deleted.

SelfLink

The SelfLink of the resource.

Quota

The database quota.

AdminLogon

The administrator login.

Password

The administrator password.

AccountAdminId

The subscription administrator PUID.

See Also

SQL Server Resource Provider Database Interfaces