Solved

Deleting data from schema

4 replies
3884 views
Translate All

I have created schemas that I want to delete but there is data stored in them. If I delete them will the data stored in it will be automatically deleted or do I need to delete the data first? Also, how do I delete that data?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

akshaagaAccepted solution

Adobe Employee

Hi @vikramsingh -

You can query the xtk:entity for the schema name to delete in the namespace ‘nms’, and use the Delete activity to delete it.

Regards,

Akshat

AkshayAnand

Community Advisor

Hi @vikramsingh

You can delete the schema by using the sql query as :-

DROP TABLE tableName;

and if you want to delete the data, you can use

--To delete all the data
Delete from tableName; 

-- To delete a specific data
delete CoulumnName from tableName where condition;

Yes, if you delete the table directly all of the data will get erased.

For you reference.

Regards

A

Translate

Milan_Vucetic

Level 9

Hi @vikramsingh

table and data within will remain in database when you delete the schema from AC.

If you want to delete it from DB as well initiate Tools/Advanced/Update database structure which will recognize that you deleted schema and prepare drop statements for your database and can confirm deletion in that window.

Regards,

Milan

Translate

Sukrity_Wadhwa

Level 4

Hi @vikramsingh,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Translate

Sukrity Wadhwa