drop Table using Synapse Notebook

dropTableSynapseNotebook.scala

/*.  

supports to 4 parameter types: int, float, bool, string.



%run /<path>/Notebook1 { "parameterInt": 1, "parameterFloat": 2.5, "parameterBool": true, "parameterString": "abc" }.

*/

%%spark
import com.microsoft.azure.synapse.tokenlibrary.TokenLibrary
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import  com.microsoft.sqlserver.jdbc.SQLServerDataSource;
val server = "myserver.sql.azuresynapse.net"
val dbname = "db_name"
val authKey = mssparkutils.credentials.getToken("DW")
val ds = new SQLServerDataSource()
ds.setServerName(server)
ds.setDatabaseName(dbname)
ds.setAccessToken(authKey)

var connection: Connection = null

try {
    connection = ds.getConnection
    val stmt = connection.createStatement
    stmt.executeUpdate("DROP TABLE cca_pricing.T")
} catch {
    case e: Throwable => println(e.getMessage)
} finally {
    if (connection != null && !connection.isClosed) {
        connection.close()
    }
}