I created a Linq to Sql class and an dbml from a LocalDB mdf.
I want to delete a field from the database.
I get this error:
Update cannot proceed due to validation errors.
Please correct the following errors and try again.
SQL71501 :: Index: [dbo].[MemberPanTickets].[MemberPanTickets$Identifiers] has an unresolved reference to Column [dbo].[MemberPanTickets].[Location].
The field is a text field. Is not part of any relationships. But, does have an index. I get the same error when only trying to delete the index.
I've deleted the field from the dbml diagram but still get the error.
How do I find and remove the reference that's causing this error?