2

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.

 

2 replies

null
    • Customer Solutions Architect
    • Moshe_Yossef
    • 6 days 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.
      • Michael_Connelly
      • 2 days ago
      • Reported - view

      Thanks .  Truncate table produced an error (line 1:0 no viable alternative at input 'truncate'), but drop table worked.  

      I also found the IRDB Query application allows for connecting to the IMDB server directly and running queries.  When connecting, we have to specify the port 12170 shown below (the Pyramid installer changes the ini file such that the server runs on this port instead of the default)

Login to reply

Content aside

  • Status Answered
  • 2 Likes
  • 2 days agoLast active
  • 2Replies
  • 23Views
  • 2 Following