다음을 통해 공유

  • 아티클

Parent 속성

Gets the Server object that is the parent of the Database object.

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

구문

‘선언
<SfcObjectAttribute(SfcObjectRelationship.ParentObject)> _
Public Property Parent As Server
    Get
    Set
‘사용 방법
Dim instance As Database
Dim value As Server

value = instance.Parent

instance.Parent = value

[SfcObjectAttribute(SfcObjectRelationship.ParentObject)]
public Server Parent { get; set; }

[SfcObjectAttribute(SfcObjectRelationship::ParentObject)]
public:
property Server^ Parent {
    Server^ get ();
    void set (Server^ value);
}

[<SfcObjectAttribute(SfcObjectRelationship.ParentObject)>]
member Parent : Server with get, set

function get Parent () : Server
function set Parent (value : Server)

속성 값

형식: Microsoft.SqlServer.Management.Smo. . :: . .Server
A Server object that is the parent of the Database object.

주의

The parent of the Database object is the instance of SQL Server on which the database is defined.

예제

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