dbdiagram now support composite foreign key!

Syntax​

//Long form
Ref name_optional {
  table1.(column1, column2,...) [<|>|-] table2.(columnA, columnB,...)
}

//Short form:
Ref name_optional: table1.(column1, column2,...) [<|>|-] table2.(columnA, columnB,...)

Example​

Table user {
  id int
  country_code int
}
Table account {
  user_id int
  country_code int
}
Ref: user.(id, country_code) - account.(user_id, country_code)

A much requested feature, dbdiagram now support importing from SQL Server!

Import from SQL Server only understand disk-based table syntax of these statements (parts that DBML support): Create Table , Create Index and Alter Table Add. For other syntax, it will either notify errors or ignore. In case of error, you just need to remove the syntax that cause the errors.

Statements should be separated by either a semicolon or the GO keyword or both in order.

We're constantly working to improve your dbdiagram experience. One of the most requested features is the ability to categorize related tables. From today, you can do that with Table Group.

To start using Table Group, use the following syntax:

tablegroup group_name {
    table_name1
    table_name2
    ...
}

For example, to create a group named access_control that includes users, groups, user_group_mapping tables (as shown in the gif above):

tablegroup access_control {
    users
    groups
    user_group_mapping
}

Please note that Table Group is a Personal Pro feature. You can learn more about Personal Pro Plan here.

We're joining the dark side! It's easier on the eyes for you night owls. Or if you just want to change a bit, sure it'll make things look better.

Ready to make your diagrams more colorful ? 🤩🌈🙈

We're excited to announce that you can now easily decorate your diagram by changing table header color.

Table header color syntax example

Table users as U [headercolor: #d35400] {
  id int
  full_name varchar
  created_at timestamp
  country_code int
}

Table Header Color is a premium feature of dbdiagram.io.

All you need to unlock this premium feature is to TWEET about us on Twitter.

Here is the guide 👇

• Step 1: Tweet about us on Twitter

• Step 2: Copy and paste your tweet link

• Step 3: Claim the premium feature

That's it. Enjoy and make beautiful diagrams 😎