Skip to main content
  • EN

I 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?

Hi ​@vxn43 ,

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.

Thank you, Takashi. I was not aware of the DatabaseDeleter.

Community Stats

31,789
Posts
120,751
Replies
39,405
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.