In this section, we will get to know all the functions and features that we can apply using the pop-up menu that is displayed by right-clicking on any Data Foundation object. By the Data Foundation object, we mean a table, view, alias table, or derived table.
When you right-click on any table placed in Data Foundation, we will able to see a menu divided into four sections.
This is the first section in this menu, and we can use it to insert the following:
An alias table based on the selected table
A derived table from the current selected table
A Data Foundation view from the current selected table/tables
The Insert menu and its options are shown in the following screenshot:
Note that if we select the Derived Table... option, it will create a derived table with the select
statement that will display (Select *
) all the columns in the selected table. Later on, we can edit the expression for the derived table and customize it as per our needs.
The second...