Expand my Community achievements bar.

SOLVED

Deleting data from schema

Avatar

Level 1

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? 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

akshaaga_0-1673634173357.png

 

Regards,

Akshat

View solution in original post

4 Replies

Avatar

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

Avatar

Level 10

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

Avatar

Administrator

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!



Sukrity Wadhwa

Avatar

Correct answer by
Employee Advisor

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.

akshaaga_0-1673634173357.png

 

Regards,

Akshat