Propriété Views
Représente une collection d'objets View. Chaque objet View représente une vue définie sur la base de données.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, _
GetType(View), SfcObjectFlags.Design)> _
Public ReadOnly Property Views As ViewCollection
Get
'Utilisation
Dim instance As Database
Dim value As ViewCollection
value = instance.Views
[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(View), SfcObjectFlags.Design)]
public ViewCollection Views { get; }
[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny,
typeof(View), SfcObjectFlags::Design)]
public:
property ViewCollection^ Views {
ViewCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(View), SfcObjectFlags.Design)>]
member Views : ViewCollection
function get Views () : ViewCollection
Valeur de propriété
Type : Microsoft.SqlServer.Management.Smo. . :: . .ViewCollection
Objet ViewCollection qui représente toutes les vues définies sur la base de données.
Notes
Specific views can be referenced by using this collection by specifying the name of the view. To add a new view to the collection, call the view constructor View.
Exemples
'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 users in the database.
Dim us As User
For Each us In db.Users
Console.WriteLine(us.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 ($us in $db.Users)
{
Write-Host $us.Name
}