Skip to main content

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!