Artículo
03/30/2012

Databases Propiedad

Representa una colección de objetos Database. Cada objeto Database representa una base de datos definida en la instancia de SQL Server.

Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,  _
    GetType(Database), SfcObjectFlags.Design)> _
Public ReadOnly Property Databases As DatabaseCollection
    Get
'Uso
Dim instance As Server
Dim value As DatabaseCollection

value = instance.Databases

[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(Database), SfcObjectFlags.Design)]
public DatabaseCollection Databases { get; }

[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny, 
    typeof(Database), SfcObjectFlags::Design)]
public:
property DatabaseCollection^ Databases {
    DatabaseCollection^ get ();
}

[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(Database), SfcObjectFlags.Design)>]
member Databases : DatabaseCollection

function get Databases () : DatabaseCollection

Valor de la propiedad

Tipo: Microsoft.SqlServer.Management.Smo. . :: . .DatabaseCollection
Objeto DatabaseCollection que representa todas las bases de datos definidas en la instancia de SQL Server.

Comentarios

Specific databases can be referenced by using this collection and specifying the name of the database. To create a new database, call the database constructor Database.

Ejemplos

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Modify a property using the Databases, Tables, and Columns collections to reference a column.
srv.Databases("AdventureWorks2008R2").Tables("Person", "Person").Columns("ModifiedDate").Nullable = True
'Call the Alter method to make the change on the instance of SQL Server.
srv.Databases("AdventureWorks2008R2").Tables("Person", "Person").Columns("ModifiedDate").Alter()

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = $srv.Databases.Item("AdventureWorks2008R2")
$tb = $db.Tables.Item("Person", "Person")
$col = $tb.Columns.Item("LastName")
$col.Nullable = $TRUE
$col.Alter()