DB CREATE/DROP Index nodes

I was looking at nodes for creating / dropping DB indices and realised there aren’t any. I then thought that maybe I should write them, but when I looked in the interfaces defining the SQL Dialects:

org.knime.database.dialect.DBSQLDialect
org.knime.database.dialect.DBSQLDialect.DataDefinitionLanguage
org.knime.database.dialect.DBSQLDialect.DataManipulationLanguage

I realised that the relevant operations are not defined (presumably they would fit most naturally in DataDefinitionLanguage alongside the CREATE/DROP/REPLACE table operations) and so any node I wrote would have to generate the SQL itself which would probably work but not allow for the convenient mechanisms currently used in the DB Plugins for specific database variants/dialects)

Therefore this is a feature request add the relevant methods to the DataDefinitionLanguage interface and implementations (and possibly add the nodes too :slight_smile: )

Steve

Hi @s.roughley,

Your feature request has been noted and a new ticket has been created. Ticket id is “AP-20184”.

2 Likes

Thanks @aliasghar_marvi

Steve

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.