문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

ScriptingOptions.DdlHeaderOnly 속성

Gets or sets the Boolean property value that specifies whether to script only the header information for data definition language (DDL) objects that have a text body, such as stored procedures and triggers.

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

public bool DdlHeaderOnly { get; set; }

속성 값

유형: System.Boolean
A Boolean value that specifies whether to script only the header information.If True, only the header information of the object is scripted.If False (default), the object is scripted completely.

The DdlHeaderOnly property applies only to objects with a text body containing a Transact-SQL statement that defines the object.

The following code example specifies that only the header information of any DDL objects will be scripted.

Visual Basic

Dim scOps As New ScriptingOptions()
scOps.DdlHeaderOnly = true

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.DdlHeaderOnly = $TRUE

커뮤니티 추가 항목

추가
표시: