Way to run an "alter table" SQL query script outside a workflow | Community
Skip to main content
manishc97360515
Level 2
Mar 19, 2018 12:11 PM UTC
Solved

Way to run an "alter table" SQL query script outside a workflow

Hi,

I want to  a SQL query for altering a table and want to saved it as a sqlscript in Campaign. Is it possible to do so? If yes,  Is there a way to execute that query without using a workflow, for example, when importing a table creation package in an Adobe Campaign environment? Please reply soon.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Adhiyan
AdhiyanAccepted solution
Employee
Mar 20, 2018 5:14 PM UTC

Hi Manish,

There is a section called SQL scripts inside the campaign interface under administration>configuration>Sql scripts.

Here you can create and execute your own scripts directly on the DB without a workflow.

Be careful and do test before making any changes as it will a change in DB directly and may not be reversed.

Regards,

Adhiyan

View reply

1 reply

Adhiyan
AdhiyanAccepted solution
Employee
Mar 20, 2018 5:14 PM UTC

Hi Manish,

There is a section called SQL scripts inside the campaign interface under administration>configuration>Sql scripts.

Here you can create and execute your own scripts directly on the DB without a workflow.

Be careful and do test before making any changes as it will a change in DB directly and may not be reversed.

Regards,

Adhiyan

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...