1

Drop tables in the In Memory Database

Is there a way to drop a table in the In Memory Database?  I see where I can delete an entire database, but not individual tables.

 

1 reply

null
    • Customer Solutions Architect
    • Moshe_Yossef
    • 22 hrs ago
    • Reported - view

    Hi Michael,
    You mean you have an IMDB database with tables that were created in the past, and are now obsolete and will not be used again ?

    You can try the following:

    1. Create a new model
    2. click Master Flow:

    3. click on the master flow icon that will now appear:

    4. delete the data flow
    5. from the general tab add a new SQL Scripty component
    6. choose the IMDB data source and data base
    7. check the "commit database changes"
    8. add the truncate script:

      and run the model - that should work.

Content aside

  • Status Answered
  • 1 Likes
  • 22 hrs agoLast active
  • 1Replies
  • 9Views
  • 2 Following