+18I have a Microsoft Access Database Table. I need to delete all the records in it and just keep the schema. Basically, the output will be an empty table. There are 10,000 records in the table.
Delete all records in Table A. Table A will be empty. Just keep the Table A schema.
I know I can use the SQLExecutor with a SQL Statement to do this, but how to do this using Transformer(s)?
What is the best way to go about this?
Best answer by takashi
Hi
I think using SQLExecutor is a way to delete all the records from an existing database table, as you mentiond already. See the help on SQLExecutor to learn how you can use it.
Alternatively, you can also use DatabaseDeleter transformer.
If you have any troubles on using the transformars, please describe the situation specifically.
Hi
I think using SQLExecutor is a way to delete all the records from an existing database table, as you mentiond already. See the help on SQLExecutor to learn how you can use it.
Alternatively, you can also use DatabaseDeleter transformer.
If you have any troubles on using the transformars, please describe the situation specifically.
