Re: Programtically drop a constraint ??

Hi Jakob,

The relationship should be named by concatenating the table names. As an
exmaple if the tables are named Customers and Orders then the relationship
should be named 'CustomersOrders'.

HTH,

Michael
"Jacob Havkrog" <a@xxx> wrote in message
news:43d3ec23@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi.
>
> I've created a relation (referential integrity) between to tables manually
> using MS Access.
>
> Now I need to delete the relation/constraint (because I need to delete a
> field), but I don't know the name.
>
> I need to delete the field "MyField" from my Delphi application - by
> executing SQL queries like
>
> ALTER TABEL MyTable DROP CONSTRAINT MyXXX
> ALTER TABEL MyTable DROP MyField
>
> I can't find anywhere in Access, where I can see the name of MyXXX.
>
> Thanks for any help!
>
> Jacob
>


.