Greetings All,
I manually created three tables using the Cloud Database tool. I specified the primary key, foreign keys and populated the tables with data.
I then created an application. I created Data Types, Data Stores and Records. I then created an grid interfaces and I was able to see my data.
After some thoughts about how I named the application and if I should have select 'From Scratch', I DELETED the application.
I then created a new application and started to create a Data Type (or is it Custom Data Type) to connect to the existing physical tables I previously used.
I then discovered that my tables (along with the data) are now gone.
I am guessing I did something wrong. If I had five applications using the same tables, it would seem counterproductive to have all of the physical tables being deleted because I deleted one application that refers to them.
Thanks for any help and advice!!
Best, Paul
Discussion posts and replies are publicly visible
Hi paulp0005,
As far as I know, Appian never touches the objects inside the application neither any database-related objects, if we delete the application. Could you please explain the exact steps that you followed?
Thanks for asking selvakumark. I would have taken screenshots if I thought my tables might go away. I think, really, I just deleted the application that had CDT connected to the tables.
Frankly, I am trying to rethink the whole 'my tables' thing. It seems like the possibly better way to go is to just have Appian manage your tables so you know who updated what and when (which my tables did not take into consideration). Still trying to wrap my brain around this new paradigm.
I try to leave schema management to Appian as much as possible. Extra stuff like views, triggers, stored procedures are separate and must be managed by you.
When creating views, keep in mind that Appian will try to create a table for them at deployment time. Add a "drop table" statement ahead of the "create view" in your DDL scripts.
If you are used to do a lot of DB stuff, then this feels odd at first.