SQL Drop Table in ext:FFDA Database | Community
Skip to main content
SkylerQu2
Level 3
April 21, 2025
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?

Amine_Abedour
Amine_AbedourAccepted solution
New Participant
April 22, 2025

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

Amine ABEDOUR
View reply

3 replies

ParthaSarathy
ParthaSarathy
New Participant
April 22, 2025

Hi @skylerqu2 ,

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.

Translate
 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    SkylerQu2Author
    Level 3
    April 22, 2025

    Hi @parthasarathy, 

     

    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

    Translate
    Amine_Abedour
    Amine_AbedourAccepted solution
    New Participant
    April 22, 2025

    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

    Translate
    Amine ABEDOUR
      Terms & ConditionsAccessibility statement

      Loading footer...