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

[manishc97360515]

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.

[Adhiyan · Accepted solution]

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