Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 2
manishc97360515
Level 2

Like

1 like

Total Posts

17 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
manishc97360515
Level 2

Like

1 like

Total Posts

17 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
manishc97360515
Level 2

19-03-2018

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

20-03-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

Answers (0)