SetConnect

ScriptObject

Database::ScriptObject

Description
Creates SQLserver sql-statements of existing tables, views, stored-procedures, functions and/or triggers.
Script Table
Options
Server

Name/address of the database-server.

Username
Username for database connection.
Password
Password for database connection.
Database
Database name.
Trusted Connection
When checked a trusted-connection is established with the database-server and no username & password is required.
Persis Security Info
"When set to false (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password.
Table
The table of which the sql-statement must be created.
Variable Name
The name of the variable to which the statement will be saved.
Only create if table doesn't exist
If enabled, the statement will include an "IF NOT EXIST ...." clause to only create the table if it doesn't exist.
Include "IF (NOT) EXIST..."
If enabled, the statement will include an "IF (NOT) EXIST .... (DROP {table})" clause..
Script View
Options
View
The view of which the sql-statement must be created.
Variable Name
The name of the variable to which the statement will be saved.
Only create if view doesn't exist
If enabled, the statement will include an "IF NOT EXIST ...." clause to only create the view if it doesn't exist.
Include "IF (NOT) EXIST..."
If enabled, the statement will include an "IF (NOT) EXIST .... (DROP {view})" clause..
Script Stored Procedure
Options
SP List
The stored-procedure of which the sql-statement must be created.
Variable Name
The name of the variable to which the statement will be saved.
Script Function
Options
Function
The function of which the sql-statement must be created.
Variable Name
The name of the variable to which the statement will be saved.
Script Trigger
Options
Trigger
The trigger of which the sql-statement must be created.
Variable Name
The name of the variable to which the statement will be saved.

Documentation

Release notes