Database Reference
In-Depth Information
6. Since we are using the
Create
option, we need to manually specify all the details,
such as the column names, data type, precision, and so on.
7. Double-click on the title bar of the
SRC_STUDENT
source structure to open the
source definition. The
Edit Tables
dialog box appears and displays all the proper-
ties of this source definition. The
Table
tab shows the name of the table, the own-
er name, and the database type. You can add a comment in the
Description
sec-
tion. The
Business name
field is empty.
8. Click on the
Columns
tab. The
Columns
tab displays the column descriptions for
the source. In the
Columns
tab, we have options to add a new column, delete an
existing column, and so on.