You can delete an organizations using two methods. Deleting
an organization also deletes all of its descendant organizations,
users, and assets (such as stores).
About this task
It is recommended that you view each database table before
deleting an organization to ensure that you are aware of what information
will be deleted.
If you are deleting an organization from a
staging server, see Staging server limitations.
Procedure
- If you have created the organization in the Organization
Administration Console, do the following in SQL:
select orgentity_id from orgentity where orgentityname =
'Organization Short name' entered during creation
delete from member where member_id =
orgentity_id from the previous query
- If you have created the organization using the Reseller
Registration commands, there are primary and secondary database tables
that have been populated. The MEMBER table
is the database table that has primary information added. Secondary
tables include the following information: MBRREL,
MBRROLE, APRVSTATUS, USERREG, ADDRESS,
and ADDRBOOK. To delete
an organization, do the following in SQL:
select users_id from userreg where logonId =
'User Name' entered during registration
delete from member where member_id =
users_id from the previous query
select orgentity_id from orgentity where orgentityname =
'Your organization name' entered during registration
select mbrgrp_id from mbrgrp where owner_id =
orgentity_id from the previous query
delete from member where member_id =
mbrgrp_id from the previous query
delete from member where member_id =
same orgentity_id as above