Script Method

SQLServer.Database.Table.Key Object

Description

Generates a series of Transact-SQL statements (script) to create the key (using ALTER TABLE).

Visual Basic

strScript = Key.Script (
[[ScriptType :=] tScriptType,]
[[ScriptFilePath :=] strFile] )

C++

HRESULT pKey->Script (
SQLOLE_SCRIPT_TYPE
tScriptType = SQLOLEScript_Default,
SQLOLE_LPCSTR
strFile = NULL,
SQLOLE_LPBSTR
pstrScript = NULL );

Elements

Element Type Description

strScript String Generated Transact-SQL script
tScriptType SQLOLE_SCRIPT_TYPE Type of script to generate
strFile String Full path and file name to use to store the Transact-SQL script