Defaults Propiedad
Representa una colección de objetos Default. Cada objeto Default representa un valor predeterminado 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(Default))> _
Public ReadOnly Property Defaults As DefaultCollection
Get
'Uso
Dim instance As Database
Dim value As DefaultCollection
value = instance.Defaults
[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(Default))]
public DefaultCollection Defaults { get; }
[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny,
typeof(Default))]
public:
property DefaultCollection^ Defaults {
DefaultCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(Default))>]
member Defaults : DefaultCollection
function get Defaults () : DefaultCollection
Valor de la propiedad
Tipo: Microsoft.SqlServer.Management.Smo. . :: . .DefaultCollection
Objeto DefaultCollection que representa todos los valores predeterminados definidos en la base de datos.
Comentarios
Specific defaults can be referenced by using this collection by specifying the name of the default. To add a new default to the collection, call the default constructor Default.
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 log files in the database.
Dim lf As LogFile
For Each lf In db.LogFiles
Console.WriteLine(lf.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 ($lf in $db.LogFiles)
{
Write-Host $lf.Name
}