Deleting Tables

Classic Servoy
1

I have a productive Servoy Server with a SQL Database.
Now we are still in developing and sometimes we have to delete some table’s ore rows.
That works fine in my developing environment. But when I export a solution and Import the solution on my productive server, the table’s and rows which I deleted in my Developing environment are still there!
What I the correct way to delete tables and rows.
Do I just have to connect to the SQL server and delete them in with Management Studio, or do I get some problems because there are still information’s about those tables and rows in the repository database?

Thanks in advanced
ttmgybta

2

ttmgybta,

When importing a solution, Servoy will only add what is needed, it will never delete database objects.
As long as you don’t reactivate a solution that uses the old tables/columns you can safely drop them using a db management tool.

As always, a backup before doing such stuff in a production environment is recommended.

Rob

3

Thanks Rob