Share via

  • Article

Propriété DefaultSchema

Obtient le schéma par défaut de l'utilisateur.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property DefaultSchema As String
    Get
    Set
'Utilisation
Dim instance As Database
Dim value As String

value = instance.DefaultSchema

instance.DefaultSchema = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public string DefaultSchema { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property String^ DefaultSchema {
    String^ get ();
    void set (String^ value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member DefaultSchema : string with get, set

function get DefaultSchema () : String
function set DefaultSchema (value : String)

Valeur de propriété

Type : System. . :: . .String
Valeur String qui spécifie le schéma de la base de données par défaut pour l'utilisateur.

Notes

The database and database objects are created in the context of the default schema unless another schema is specified.

Exemples

VB

'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 information about the database.
Console.WriteLine("Name = " + db.Name.ToString)
Console.WriteLine("ID = " + db.ID.ToString)
Console.WriteLine("Owner = " + db.Owner.ToString)
Console.WriteLine("Parent = " + db.Parent.ToString)
Console.WriteLine("State = " + db.State.ToString)
Console.WriteLine("Status = " + db.Status.ToString)
Console.WriteLine("User Name = " + db.UserName.ToString)
Console.WriteLine("DBO Login = " + db.DboLogin.ToString)
Console.WriteLine("Version = " + db.Version.ToString)
Console.WriteLine("Service Broker = " + _
db.ServiceBroker.ToString)
Console.WriteLine("Replication Options = " + _
db.ReplicationOptions.ToString)
Console.WriteLine("Default File Group = " + _
db.DefaultFileGroup.ToString)
Console.WriteLine("Default FTS catalog = " + _
db.DefaultFullTextCatalog.ToString)
Console.WriteLine("Default Schema = " + _
db.DefaultSchema.ToString)

PowerShell

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

Write-Host "Name =" $db.Name
Write-Host "ID =" $db.ID
Write-Host "Owner =" $db.Ownder
Write-Host "Parent =" $db.Parent
Write-Host "State =" $db.State
Write-Host "Status =" $db.Status
Write-Host "User Name =" $db.UserName
Write-Host "DBO Login =" $db.DboLogin
Write-Host "Version =" $db.Version
Write-Host "Service Broker =" $db.ServiceBroker
Write-Host "Replication Options =" $db.ReplicationOptions
Write-Host "Default File Group =" $db.DefaultFileGroup
Write-Host "Default FTS catalog =" $db.DefaultFullTextCatalog
Write-Host "Default Schema =" $db.DefaultSchema