Database Output

Top Previous Topic Next Topic  Print this topic

The Database Output diagram object represents the structure of the Table(s) that will be created or modified.

 

The following example describes a Table's structure, which contains a list of all USA's presidents. The root element, named Database, which contains one Schema. The Schema has one table that consists of a single Row Sequence of three columns: Presidency, President and party.

 

db_output_sample

Also, a pre-processing SQL Query has been inserted in order to create the Presidents table.

 

db_output_sample(1)

 

The output will consist of a series of SQL commands, that can be run selecting the Execute SQL button located in the Execute group, under the Home tab.

 

db_output_sample(2)