Sql Diagram Symbols. When you make a change in the diagram pane the criteria pane and sql pane are updated to reflect your change. For example if you select a column for output in a table or table valued object window in the diagram pane the query and view designer adds the data column to the criteria pane and to the sql statement in the sql pane.
Table of symbols copy link to this section. This list does not include symbols indicating format conventions which are not part of the language there is a separate table for symbols used in objectscript. Step 2 from database diagram select a table.
Physical er models show all table structures including column name column data type column constraints primary key foreign key and relationships between tables.
You can also modify the symbol size color and text according to your specific requirements. Entity relationship diagram symbols about entity relationship diagram. For example if you select a column for output in a table or table valued object window in the diagram pane the query and view designer adds the data column to the criteria pane and to the sql statement in the sql pane. I m looking at a database diagram generated by mysql workbench actually dbdesigner4 but i m not familiar with it so i couldn t figure out some of the symbols it uses for relationships and fields.
