You must have either administration privilege or modify access permission to the columns to delete a relationship. If you created a relationship (link) between tables using the Web interface, you can also delete it from the Web interface. But if the relationship was created using TQL, you must also use TQL to delete it.
To delete a relationship using TQL, use an
ALTER TABLE...DROP FOREIGN KEY... statement. To delete a relationship from the Web interface:
Click on the DATA icon on the top navigation bar and then on Worksheets.
- Click on the name of the data source you from which you want to remove the relationship.
Find the relationship you want to delete, and click Delete.