Designing an SQL Database in Visio

Question

I want to create my SQL database schema in Visio

But the default database is Microsoft Access, and some data types do not exist there (for example, tinyint).

How to change database type to SQL? I am using visio 2007

Thank!

Answer 1

To change the driver of the target database.

• From the "Database" menu, select "Options" and click "Drivers."
• On the Drivers tab, select the Visio driver for your target database management system.
• Click Configure and select the check box for the appropriate ODBC driver.

- SQL- ( ) tinyint

Answer 2

Visio 2010, " " > " " > ""