Way to run an "alter table" SQL query script outside a workflow | Community
Skip to main content
Level 2
March 19, 2018
Solved

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

  • March 19, 2018
  • 1 reply
  • 1874 views

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.
Best answer by Adhiyan

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

1 reply

Adhiyan
Adobe Employee
AdhiyanAdobe EmployeeAccepted solution
Adobe Employee
March 20, 2018

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