The create table dialog allows users to create tables within their database using a graphical user interface.
The create table dialog generates the SQL Query which is going to create the table in the bottom pane. Since this pane is editable, users can change the query if they wish to do so before creating the table.
In addition to being able to specify primary keys, data types, sizes and other characteristics of each column, this table also allows users to specify foreign-key references when creating a table. So in the above example, sample has a column called account which references the table ACCOUNTS, foreign key NUMBER. If you click on the Foreign Key Cell, the following dialog will pop-up :
This dialog contains a drop-down box which lists all the tables in the current schema. (You can only create foreign-key relationships within the current schema) When you select a table, the column drop-down combo box will be updated with the column information for the given table. Upon selecting a particular column, the data type of the column (which is a read-only field) will be displayed below the column name.
Finally when you hit select, this information will be copied into the table and the appropriate SQL Query will be generated.