bug in Visio 2003 when reverse engineering a database

P

PhilS

When reverse engineering a SQL Server database containing a table with a
tinyint identity column Visio displays the datatype as smallint instead of
tinyint. Occurs for both SQL Server 2000 and 2005. The datatype is okay if
the column is not an identity column. Thanks!

visio version:11.4301.8107

SQL Script to test against:

CREATE TABLE [dbo].[Table_2](
[col1] [tinyint] IDENTITY
)

CREATE TABLE [dbo].[Table_1](
[col1] [tinyint] NULL
)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top