Deleting data from schema | Community
Skip to main content
V
VikramSingh
New Participant
December 22, 2022
Solved

Deleting data from schema

  • December 22, 2022
  • 4 replies
  • 3813 views

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.
Best answer by akshaaga

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

4 replies

akshaaga
akshaagaAccepted solution
Employee
January 13, 2023

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

    Sukrity_Wadhwa
    Sukrity_Wadhwa
    Employee
    January 12, 2023

    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
    Milan_Vucetic
    Milan_Vucetic
    New Participant
    December 28, 2022

    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

      AkshayAnand
      AkshayAnand
      New Participant
      December 22, 2022

      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

        Terms & ConditionsAccessibility statement

        Loading footer...