Skip to main content
Level 3
Apr 21, 2025 5:51 PM UTC
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
Community Advisor and User Group Leader
Apr 22, 2025 8:05 PM UTC

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

3 replies

ParthaSarathy
Community Advisor
Community Advisor
Apr 22, 2025 4:10 PM UTC

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
SkylerQu2Author
Level 3
Apr 22, 2025 4:13 PM UTC

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
Community Advisor and User Group Leader
Amine_AbedourCommunity Advisor and User Group LeaderAccepted solution
Community Advisor and User Group Leader
Apr 22, 2025 8:05 PM UTC

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