Page History

...

In the example above the domain is called spt.deepnetid.com.  Please replace this with the name of your own domain.

Execute the query

In the result we see the id = 5.  For future reference this will be refered to as the domain_id

Try and delete the domain by executing the following query:

delete from domain where name =  'spt.deepnetid.com'

You will now see an error which should give details as to why the domain cannot be deleted... for example...

Image Added

This error tells us that a foreign key constraint fails where the domain_id is referenced in the table role_domain

So we can use the following delete query.  (Remember domain_id = 5)

delete from role_domain where domain_id = 5