ScriptDestinationTable Method

SQLServer.Database.Publication.Article Object

Description

Produces a Transact-SQL script that can be used to create the subscribing (destination) table. This script includes the column subset if the Article is vertically partitioned.

Visual Basic

strSQLScript = Article.ScriptDestinationTable (
[ScriptType :=] tScriptOptions,
[[ScriptFilePath :=] strFile] )

C++

HRESULT pArticle->ScriptDestinationTable (
SQLOLE_SCRIPT_TYPE
tScriptOptions = SQLOLEScript_Default,
SQLOLE_LPCSTR strFile = NULL,
SQLOLE_LPBSTR pstrSQLScript = NULL );

Elements

Element Type Description

strSQLScript String Returned Transact-SQL script
tScriptOptions SQLOLE_SCRIPT_TYPE Script options
strFile String Full path and file name of Transact-SQL script file to create