Drop relationship
One or several Direct Query relationships can be dropped from the data model in the section directquery section of a load script by means of a DROP RELATIONSHIP statement.
DROP RELATIONSHIP is useful if there is a previous IMPORT LIVE <datamodelobject> in your load script that contains a Data model manager-defined relationship you want to remove.
Syntax:
DROP RELATIONSHIP BETWEEN tablename {, tablename2 ...}
Information noteFor TableName, you can use quoted name name references. For example, ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | LITERAL_NUMBER)).
Example:
DROP RELATIONSHIP BETWEEN Table1, Table2