How to deleted a list with lookup column programatically

Question

I have created a list with lookups and dependent lookup fields.

Enforce the relationship to restrict to deleted.

Now i have to delete he list programatically.

How to delete the list.

---

kukdai

Answer 1

Break the lookup dependence, programmatically.

After that you will be able to delete list.

---

Каждый админ должен: проложить сеть, посадить кактус, вырастить кота

Answer 2

how to breakup the lookup dependency programatically i dont see any menthods there do you have any refrences or method names.

---

kukdai

Answer 3

Primarily you will have to delete the field to delete the list. With regards to getting hold of the relationship check the code below which sets the relationship to cascade.

SPFieldLookup teamLeaderField = (SPFieldLookup)projectsList.Fields.GetFieldByInternalName(teamLeaderFieldInternalName);
teamLeaderField.LookupField = employeesList.Fields["Title"].InternalName;
teamLeaderField.RelationshipDeleteBehavior = SPRelationshipDeleteBehavior.Cascade;
teamleaderField.Indexed = true;
teamLeaderField.Update();

---

Varun Malhotra
=================
If my post solves your problem could you mark the post as Answered or Vote As Helpful if my post has been helpful for you.

Answer 4

Do you want to delete the list (child list) which has look fields or the parent list?

---

Regards,
Shantha Kumar .T | MCPD - SharePoint Developer 2010 | MCITP - SharePoint Administrator 2010
(B) Shantha Kumar's Blog | (T)Follow me

Answer 5

Hey,

This link will helps you out

http://blog.mastykarz.nl/sharepoint-programmatically-provisioning-lookup-fields/

http://www.chaholl.com/archive/2011/02/02/sharepoint-2010-bug-the-primary-lookup-field-cannot-be-deleted.aspx

http://academy.uspja.com/blog/ayman-el-hattab/programmatically-enforcing-relationship-behavior-for-lookup-columns-in-sharepoint-2010

Let me know if you have any queries :)

---

"The Only Way To Get Smarter Is By Playing A Smarter Opponent"

Answer 6

The way to break dependency:

using (var site = new SPSite("http://server/"))
{
    using (var web = site.OpenWeb())
    {
        var list = web.Lists.TryGetList("MyListTitle");
        if (list != null)
        {
            var lookupField = (SPFieldLookup) list.Fields["LookupFieldName"];
            lookupField.RelationshipDeleteBehavior = SPRelationshipDeleteBehavior.None;
            lookupField.Update();
        }
    }
}

---

Каждый админ должен: проложить сеть, посадить кактус, вырастить кота

Answer 7

actually i have to delete the dependent column first setting the delete behavior to true.

then i deleted the dependent columns first and the main lookup field.

this way it worked for me thanks everyone.

---

kukdai