SHARE
TWEET

Untitled

a guest Jul 22nd, 2019 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*Use this only on DESPERATE cases when the items are not getting deleted properly from ADMIN or CMS*/
  2. /*
  3. DECLARE @contentTypeId INT
  4. DELETE FROM tblWorkContentProperty WHERE fkPropertyDefinitionID IN (SELECT pkID FROM tblPropertyDefinition WHERE fkContentTypeID = @contentTypeId)
  5. DELETE FROM tblContentProperty WHERE fkPropertyDefinitionID IN (SELECT pkID FROM tblPropertyDefinition WHERE fkContentTypeID = @contentTypeId)
  6. DELETE FROM tblContentLanguage WHERE fkContentID IN (SELECT pkId FROM tblContent WHERE fkContentTypeID = @contentTypeId)
  7. DELETE FROM tblWorkContent WHERE fkContentID IN (SELECT pkId FROM tblContent WHERE fkContentTypeID = @contentTypeId)
  8. DELETE FROM tblContentSoftLink WHERE fkOwnerContentID IN  (SELECT pkId FROM tblContent WHERE fkContentTypeID = @contentTypeId)
  9. DELETE FROM tblContent WHERE fkContentTypeID = @contentTypeId
  10. DELETE FROM tblPropertyDefinition WHERE fkContentTypeID = @contentTypeId
  11. DELETE FROM tblContentType WHERE pkID = @contentTypeId
  12. */
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top