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

ScriptingOptions.DdlBodyOnly 속성

Gets or sets the Boolean property value that specifies whether to script only the text definition 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 DdlBodyOnly { get; set; }

속성 값

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

The DdlBodyOnly 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 text definition of any DDL objects will be scripted.

Visual Basic

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

PowerShell

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

커뮤니티 추가 항목

추가
표시: