Database.PrimaryFilePath Database.PrimaryFilePath Database.PrimaryFilePath Property

정의

데이터베이스 주 파일이 있는 운영 체제 디렉터리를 가져옵니다. Gets the operating system directory that contains the primary file for the database.

public:
 property System::String ^ PrimaryFilePath { System::String ^ get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Expensive | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone)]
public string PrimaryFilePath { get; }
Public ReadOnly Property PrimaryFilePath As String
속성 값

A String 주 데이터베이스 파일의 경로를 지정 하는 값입니다. A String value that specifies the path to the primary database file.

구현

예제

VBVB

' compile with:'  
' /r:Microsoft.SqlServer.Smo.dll  
' /r:Microsoft.SqlServer.Management.Sdk.Sfc.dll  
' /r:Microsoft.SqlServer.ConnectionInfo.dll  
' /r:Microsoft.SqlServer.SqlEnum.dll   

Imports Microsoft.SqlServer.Management.Smo  
Imports Microsoft.SqlServer.Management.Sdk.Sfc  

Public Class A  
   Public Shared Sub Main()  
      ' 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("Primary File Path = " + db.PrimaryFilePath.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)  
   End Sub  
End Class  

PowerShellPowerShell

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

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 "Primary File Path =" $db.PrimaryFilePath  
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  

적용 대상