다음을 통해 공유

  • 아티클

Owner 속성

Gets the database principal that is the owner of the database.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo.dll의 Microsoft.SqlServer.Smo

구문

‘선언
<SfcPropertyAttribute> _
Public ReadOnly Property Owner As String
    Get
‘사용 방법
Dim instance As Database
Dim value As String

value = instance.Owner

[SfcPropertyAttribute]
public string Owner { get; }

[SfcPropertyAttribute]
public:
property String^ Owner {
    String^ get ();
}

[<SfcPropertyAttribute>]
member Owner : string

function get Owner () : String

속성 값

형식: System. . :: . .String
A String value that specifies the database principal that owns the database.

주의

The database owner can be changed by using the SetOwner method.

예제

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