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
)
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
)