| |
| |
To delete a relation In a database, tables are usually linked together in a logical way. A link between two tables is called a "relation". A relation always involves two tables ad two columns from them (one can create a relation between a table and itself for representing a tree like structure) between two tables, right click on the line connecting the tables:
In the menu, select the Remove option. You will then be asked to confirm the removal:
When a relation is removed, several things happen. Here are some things to notice:
The line connecting the two tables is removed.
The JOIN The JOIN is a SQL command used to retrieve data from 2 or more database tables with existing relationship based on a common attribute statement is removed from the SQL Query.
If table is no longer linked to anything, an error message appears in the SQL/Results Preview Panel.
Foreign Key icon is removed.
The next section will describe using the Query Management Panel to retrieve exactly the data you want.
Related Topics