Deleting data from schema

[VikramSingh]

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? 

[AkshayAnand]

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

[Milan_Vucetic]

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

[Sukrity_Wadhwa]

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!

[akshaaga · Accepted solution]

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