This article explains all details on customizing table styles on diagram.
ApexSQL Model offer optional customization of the table elements to achieve better performance overview with:
- Selecting which table rows will be displayed
- Highlighting datatypes and/or key rows
- Displaying icons for key rows, additional column for representing key rows, primary key separator
- Customizing table header
- Include schema in name
- Title alignment
- Make title bold
- Title position
- Grouping style
In the next chapter all above customization options are explained in fine details through screenshots on table design for each customization made.
Customization options are aggregated in Table style tab in Options dialog.
- None – displays the table name only
- Keys – displays key rows along with the table name
- All – all rows will be displayed, keys and non-keys, along with table name.
By choosing Keys, the key name will be syntax highlighted with an appropriate color (every key type has specific color), and choosing Datatypes highlights datatypes (every datatype has specific color)
Both (Keys and Datatypes)
(Primary keys, Foreign keys and Alternate keys)
The Icons option group is set of three options (Primary key, Foreign keys and Alternate keys) where each will determine if an icon is displayed for the respective key type.
By selecting Key column an additional column which represents short name e.g. PK of the key type is displayed.
Primary key separator
Primary key separator establishes an additional line under primary key
Trimmed by sides
The primary key line separator can be styled to provide spacing on either end with Trimmed by sides
Include schema includes the schema name in table header.
Bold bolds table name (includes schema if exists),
Name only bolds the table name only (not schema name if exists)
Center centers the table name.
Name inside of border
Unchecking the Name inside of the border puts the table name outside borders
Separator adds a line below table name.
Adding a table to a group, automatically assigns a group color. There are three styles for grouping: Header, Lines and Block
Here are some shots on white theme
There is a Font option in General tab in the Options window with predefined fonts.
Segoe UI font looks like this