How to delete a publication in Tridion

It's often very hard to trace back everything that got published from a given publication.

One easy solution can be done in the backend (note: this may not be supported by Tridion and could void your warranty).

1) Grab the publication ID:

a) through the interface by mousing-over a publication and grab the highlighted number tcm:xx-XX-xx

b) through the backend with a simple: _{select * from publications} and find the ID for the publication you'd like to delete.

2) Now you can delete the publication starting with dependencies first:

_{delete from ITEM_STATES where PUBLICATION_ID = XX}

_{delete from PUBLICATION_ITEM_ASSOCIATIONS where PUBLICATION_ID = XX}

_{delete from PUBLISH_TRANSACTIONS where PUBLICATION_ID = XX}

_{delete from TRUSTEE_RIGHTS where PUBLICATION_ID = XX}

_{delete from PUBLICATION_PRIORITIES where CHILD_PUBLICATION_ID = XX}

_{delete from PUBLICATIONS where ID = XX}

 

Related articles, courtesy of Zemanta:

• Get Child publications in Tridion
• Blockers for deleting keywords in Tridion
• Delete keywords in Tridion