Drop Relationships

Hi there,

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)

one-to-many

How can I drop the relationship using SQL?

Hope you can help me... I am searching a solution for daysyou might need to know the name of the constraint

see ACC2000: Create and Drop Tables and Relationships Using SQL DDL (http://support.microsoft.com/kb/q209037/)

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!

Drillthrough

Hi,
While enable drillthrough on a cube. There is a option to extra add tables.
How is the relationship mananged for these table; do i need to join it to the
fact table or the dimension tables.
How to remove a table added through this option.
Thanks a lot in advance.
Regards,
Yash
You need to write the join clause in the Filter tab. If you uncheck all
columns used by the additional tables and save they will be gone
Regards,
Plamen
"Yash" <Yash@.discussions.microsoft.com> wrote in message
news:5D9CD437-D326-415E-880F-EF1D590D3B88@.microsoft.com...
> Hi,
> While enable drillthrough on a cube. There is a option to extra add
tables.
> How is the relationship mananged for these table; do i need to join it to
the
> fact table or the dimension tables.
> How to remove a table added through this option.
> Thanks a lot in advance.
> --
> Regards,
> Yash
>

Drillthrough

Hi,
While enable drillthrough on a cube. There is a option to extra add tables.
How is the relationship mananged for these table; do i need to join it to th
e
fact table or the dimension tables.
How to remove a table added through this option.
Thanks a lot in advance.
--
Regards,
YashYou need to write the join clause in the Filter tab. If you uncheck all
columns used by the additional tables and save they will be gone
Regards,
Plamen
"Yash" <Yash@.discussions.microsoft.com> wrote in message
news:5D9CD437-D326-415E-880F-EF1D590D3B88@.microsoft.com...
> Hi,
> While enable drillthrough on a cube. There is a option to extra add
tables.
> How is the relationship mananged for these table; do i need to join it to
the
> fact table or the dimension tables.
> How to remove a table added through this option.
> Thanks a lot in advance.
> --
> Regards,
> Yash
>