Level 3

Solved

SQL Drop Table in ext:FFDA Database

Hello,

Previously in v7 the following SQL code would be suitable to drop a schema's table:

drop table <table name>

In v8, for tables which exist in the FFDA database, this SQL code throws an error.

Can someone please point me toward the correct documentation for accessing FFDA tables with SQL commands in v8?

Best answer by Amine_Abedour

Hello @skylerqu2,

In a js activity you should use :

sqlExecOnDataSource ("drop table <table>","nms:extAccount:<InternalName>")

Here are more infos about this function.

Br,

Amine ABEDOUR

Community Advisor

Select FDA data source and its external account in SQL code activity

And make sure you have database permission to delete the table from database.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Level 3

Thank you for the helpful reply. I am trying to execute this SQL code within a javascript activity:

sqlExec("drop table <table>")

Is there a similar configuration that can be made within a js activity?

Thanks,

Skyler

Accepted solution

Community Advisor

In a js activity you should use :

sqlExecOnDataSource ("drop table <table>","nms:extAccount:<InternalName>")

Here are more infos about this function.

Br,

Amine ABEDOUR

Sign up