Customizing table element displays in ApexSQL Model

Applies to
ApexSQL Model

Summary
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.

Options

Customization options are aggregated in Table style tab in Options dialog.

Rows

  • 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.

None

Keys

All

Syntax highlighting

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)

Keys

Datatypes

Both (Keys and Datatypes)

Keys

Icons

(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.

Key column

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

Table header

Include schema

Include schema includes the schema name in table header.

Bold

Bold bolds table name (includes schema if exists),

Name only

Name only bolds the table name only (not schema name if exists)

Center

Center centers the table name.

Name inside of border

Unchecking the Name inside of the border puts the table name outside borders

Separator

Separator adds a line below table name.

Grouping style

Adding a table to a group, automatically assigns a group color. There are three styles for grouping: Header, Lines and Block

Header

Lines

Block

White theme

Here are some shots on white theme

Font customization

There is a Font option in General tab in the Options window with predefined fonts.

Segoe UI font looks like this

Consolas