Hello
I have a table in my platform that is consuming about 1 gig of data. Can I delete it without messing up my apps
OSUSR_MLE_DEPRECATED_SAMPLE_PRODUCTIMAGE
OutSystemsSampleDataDB.DEPRECATED_Sample_ProductImage
If so.. whats the best way to delete this?
Thanks
Hi Heather,
I think you can find the entity by adding the reference of OutSystemsSampleDataDB module and the entity and then you can right click the entity >> View Data to see the data in it
Best Regards
Devendra
there are many components on the Forge to deal with database in a safer way than manually.
The most common tool used is https://www.outsystems.com/forge/component-overview/423/dbcleaner
Regards
I use the cleaner on steroids. But I want to know if this table can safely be removed without messing up my other applications.
If the table is not used by other applications it is fine to remove it.
any idea on how I can delete this table? is there a SQL query I can use to see this data and to delete data based on dates in this table?
You can delete the data by creating a Sql Query . Just create a Aggregate to see the data and if you have Date column in it than you can write a Sql Query to delete the data based on dates.
Hi..
thanks for reaching back... How can I see the data.. Im having trouble find my way
You can check the data by creating a aggregate from the entity
By using Sql Query also you can check the data
1. Add output entities as the same you are returning from query
2. Select query that returns all the columns
3. Click the Test button.
Best regards
I do appreciate your help.. but I cant find that table.. any other hints to query it?
Thank you!! that is the info I needed to get into the right direction.