/*Use this only on DESPERATE cases when the items are not getting deleted properly from ADMIN or CMS*/
/*
DECLARE @contentTypeId INT
DELETE FROM tblWorkContentProperty WHERE fkPropertyDefinitionID IN (SELECT pkID FROM tblPropertyDefinition WHERE fkContentTypeID = @contentTypeId)
DELETE FROM tblContentProperty WHERE fkPropertyDefinitionID IN (SELECT pkID FROM tblPropertyDefinition WHERE fkContentTypeID = @contentTypeId)
DELETE FROM tblContentLanguage WHERE fkContentID IN (SELECT pkId FROM tblContent WHERE fkContentTypeID = @contentTypeId)
DELETE FROM tblWorkContent WHERE fkContentID IN (SELECT pkId FROM tblContent WHERE fkContentTypeID = @contentTypeId)
DELETE FROM tblContentSoftLink WHERE fkOwnerContentID IN  (SELECT pkId FROM tblContent WHERE fkContentTypeID = @contentTypeId)
DELETE FROM tblContent WHERE fkContentTypeID = @contentTypeId
DELETE FROM tblPropertyDefinition WHERE fkContentTypeID = @contentTypeId
DELETE FROM tblContentType WHERE pkID = @contentTypeId
*/