Display data types in a database model diagram

Office 2010 support is ending soon

Upgrade to Microsoft 365 to work anywhere from any device and continue to receive support.

Upgrade Now
  1. Open the database model diagram.

  2. On the Database tab, in the Manage group, click Display Options.

  3. In the Database Document Options dialog box, click the Table tab, and then, under Data types, click Show physical or Show portable.

  4. Click OK.

You can also open the Types window in a database model diagram:

  • On the Database tab, in the Show/Hide group, select the Types check box.

Top of Page

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.