GenerateSQL Method (Database) (SQL-DMO)

The GenerateSQL method returns a string containing a Transact-SQL command batch that can be used to create the the Microsoft® SQL Server™ database defined by the properties of the Database object.

Applies To

Database Object

Syntax

object.GenerateSQL() as String

Part Description
object Expression that evaluates to an object in the Applies To list

Returns

A Transact-SQL command batch as a string.

Remarks

The GenerateSQL method generates a Transact-SQL batch that creates a database. The method fails if the Database object used references an existing SQL Server database. Use the Script method of the Database object to create a Transact-SQL command batch defining an existing database.

Prototype (C/C++)

HRESULT GenerateSQL(SQLDMO_LPBSTR pRetVal);


Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.


  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.