SQL Drop Table in ext:FFDA Database

[SkylerQu2]

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?

[ParthaSarathy]

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.

[SkylerQu2]

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

[Amine_Abedour · Accepted solution]

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