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?
Solved! Go to Solution.
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.
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.
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'.