deleting relationships online

[storm1976]

Ok heres the scenario.

I uploaded a database to our website a few months ago, with many tables in some related. There were also tables which were empty for future development.

So now it has come round to the time to work on these tables. However, there is a relationship between two tables which needs to be deleted.

The question is: is there a way of deleting a relationship using sql or would i need to download the database and delete it manually?

Cheers in advance

 

[mp9]

To delete a relationship, you can use SQL of the form:

ALTER TABLE yourTableNameHere
DROP CONSTRAINT constraintNameHere;

Of course to use this you'll need to know the name of the realtionship, which may be unlikely

http://www22.brinkster.com/accessory/