Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
|
There are four methods of creating a table entity in the ER Modeler. 1. Right clicking within a sheet and choosing New Table from the menu. This puts a new table where the click occurs. The Table Properties window appears to enter the table information. The table columns and properties vary based on the database vendor and version selected when the ER model document was created. 2. Right clicking on the Tables node within the Model Browser and choosing New Table. This puts a new table centered within the current view of a sheet. 3. Left clicking in the Palette on the Table Entity icon and then left clicking with the Table Entity icon within a sheet. This puts a new table where the click occurs. 4. Within the Menu Bar, selecting Edit > New Table. This puts a new table centered within the current view of a sheet. It is also possible to import a table from an existing database. Information on how to import schema objects into a model is available under the Reverse Engineering section.Table Properties Once a table has been created within a sheet, it may be double clicked or right clicked to alter its properties. Its properties may also be viewed and altered by right clicking on its node in the Model Browser. There are four tabs available on the table properties windows. General tab The General Tab allows selection of Database, Schema, Table Name, Column editing and creation, Column Data Type, Column Length and Allow Nulls. The datatypes available to columns varies based on database vendor and version selected for the current ER Model. New columns can be entered by editing the column list and their data types and values are editable. Table column parameters are displayed in the pane at the bottom of the table properties window, and can also be edited. Once a database name has been typed in any table properties dialog for an ER Model, that database becomes available in the drop-down list of any table in the model to save time when modifying existing tables or creating new ones. The list of databases grows as more are referenced. The same is true of Schemas drop-down menu. Storage tab Displays Table Storage information for the current table. The information displayed here varies based on database vendor and version, allowing modifications for database administration optimization. Comments tab The Comments Tab displays any user-entered comments for that table. SQL Preview tab The SQL Preview displays the DDL that would be created if the table were to be generated as a script from the ER Model.
|
|