![]() |
Manipulating Tables |
![]() |
ERD functions specific to displayed database tables are outlined below. |
![]() |
Creating a New Table |
Note: Selection of a database connection and associated schema is not mandatory but provides the application with a reference point in when generating SQL scripts and selecting table column data types. |
|
Adding a Table from an Existing Database |
The steps below outline the process for adding a single or multiple table(s) from an open data source to the ERD diagram. |
|
Altering a Table |
Tables structures may be viewed in greater detail by double-clicking the table of interest. The resulting dialog allows for the modification of table columns and constraints. Tables may be renamed, associated with open connections as well as columns reordered. |
Creating a New Table Relationship |
A new table relationship creates the foreign key constraint references between the selected entities. |
|
The new relationship will be depicted using a single line from the referencing table to the referenced table. |
Deleting a Table Relationship |
Removing a relationship between tables will sever the foreign key link. This will be reflected both in the table's description dialog and within any generated SQL. |
|
The visible line linking the two tables should now be removed and reflected in respective table structures. |
Deleting Tables |
Deleting a table or tables from the ERD will remove those tables from the ERD. |
|
Generating SQL Scripts |
SQL CREATE TABLE scripts may be generated using the Generate SQL scripts from the ERD toolbar. Each generated statement bases its content on the ERD only - no further calls to the database are made. |
|