Compartir a través de

  • Artículo

Schemas Propiedad

Representa una colección de objetos Schema. Cada objeto Schema representa un esquema definido en la base de datos.

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(Schema), SfcObjectFlags.Design)> _
Public ReadOnly Property Schemas As SchemaCollection
    Get
'Uso
Dim instance As Database
Dim value As SchemaCollection

value = instance.Schemas

[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(Schema), SfcObjectFlags.Design)]
public SchemaCollection Schemas { get; }

[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny, 
    typeof(Schema), SfcObjectFlags::Design)]
public:
property SchemaCollection^ Schemas {
    SchemaCollection^ get ();
}

[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(Schema), SfcObjectFlags.Design)>]
member Schemas : SchemaCollection

function get Schemas () : SchemaCollection

Valor de la propiedad

Tipo: Microsoft.SqlServer.Management.Smo. . :: . .SchemaCollection
Objeto SchemaCollection que representa todos los esquemas definidos en la base de datos.

Comentarios

Specific schemas can be referenced by using this collection by specifying the name of the schema. To add a new schema to the collection, call the schema constructor Schema.

Ejemplos

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")

'Display all the schemas in the database.
Dim sc As Schema
For Each sc In db.Schemas
   Console.WriteLine(sc.Name)
Next

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")

Foreach ($sc in $db.Schemas)
{
   Write-Host $sc.Name
}