Server.EnumDirectories 메서드

Enumerates a list of directories relative to the specified path.

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

구문

‘선언
Public Function EnumDirectories ( _
    path As String _
) As DataTable
‘사용 방법
Dim instance As Server 
Dim path As String 
Dim returnValue As DataTable 

returnValue = instance.EnumDirectories(path)

public DataTable EnumDirectories(
    string path
)

public:
DataTable^ EnumDirectories(
    String^ path
)

member EnumDirectories : 
        path:string -> DataTable

public function EnumDirectories(
    path : String
) : DataTable

매개 변수

• path
  유형: System.String
  A String value that specifies an operating system path.

반환 값

유형: System.Data.DataTable
A DataTable system object value that contains a list of directories relative to the specified path. The table describes the different columns of the returned DataTable.

주의

This method can be used on any directory. It is not limited to the SQL Server path.

예

C#

Server srv = new Server("(local)");

DataTable d = srv.EnumDirectories("C:\\Program Files\\Microsoft SQL Server");
foreach (DataRow r in d.Rows)
{
   Console.WriteLine("============================================");
   foreach(DataColumn c in d.Columns)
   {
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());
   }
}

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

$d = $srv.EnumDirectories("C:\Program Files\Microsoft SQL Server ")

Foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}

참고 항목

참조

Server 클래스

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

메서드 호출

메서드 호출

서버 관리