Поделиться через

  • Статья

Свойство DefaultSchema

Gets the default schema of the user.

Пространство имен:  Microsoft.SqlServer.Management.Smo
Сборка:  Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<SfcPropertyAttribute(SfcPropertyFlags.Expensive)> _
Public Property DefaultSchema As String
    Get
    Set
'Применение
Dim instance As Database
Dim value As String

value = instance.DefaultSchema

instance.DefaultSchema = value

[SfcPropertyAttribute(SfcPropertyFlags.Expensive)]
public string DefaultSchema { get; set; }

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

[<SfcPropertyAttribute(SfcPropertyFlags.Expensive)>]
member DefaultSchema : string with get, set

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

Значение свойства

Тип System. . :: . .String
A String value that specifies the default database schema for the user.

Замечания

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

Примеры

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

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

'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)