A
Alan R
I have an application that accesses a mdb file and I want to use sql to drop
a table column and re-add it as a new data type (integer to long integer)
I figured out I could copy the field to a new tmp field, drop field and
recreate as long integer then copy data back. However I can not drop the
field as it has relationship (constraint i guess) to another table. I dont
know the name of this releationship to drop it and Microsoft access only
gives me a diagram of the relationship not its name. I could do this in
Access by deleting the link in the display however I have to do this with SQL
as my client does not have access at their site. can someone help. How do i
get the names of the table relationships of an access database? Thanks in
advance. Is there a default naming standard?
a table column and re-add it as a new data type (integer to long integer)
I figured out I could copy the field to a new tmp field, drop field and
recreate as long integer then copy data back. However I can not drop the
field as it has relationship (constraint i guess) to another table. I dont
know the name of this releationship to drop it and Microsoft access only
gives me a diagram of the relationship not its name. I could do this in
Access by deleting the link in the display however I have to do this with SQL
as my client does not have access at their site. can someone help. How do i
get the names of the table relationships of an access database? Thanks in
advance. Is there a default naming standard?