var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Drop Relationships
I would Like to delete a relationship by SQL Syntax!
When I go to M-Access I see the relationship with the name companiesVisitors
and this is how it is represented...
Companies(Company_ID) ------ Visitors(VisitorCompany)
How can I drop the relationship using SQL?
Hope you can help me... I am searching a solution for days
you might need to know the name of the constraint
see ACC2000: Create and Drop Tables and Relationships Using SQL DDL
but if you're in the relationship window already, just click on the line joining the two boxes and delete it
That didn't help to much... I need the SQL to remove a relationship....
I tried to delete the constraints, but that does not help me to much... because my Constraints have strange names such as "Rel_158FB2CC_919D_462B".... It's a totally random name given by Access
then when you create the relationship, you should assign it a constraint name
but I can't do anything now, because is a software update.... it's to import data to new database formats... I can't guess wich names the constraint have.... it should be done in the beggining!