Toad World® Forums

user datatypes scale and precision


#1

Hello Michael,

With the latest beta 1019, I still find scale and precision with some of my user datatypes when extracting the ddl for a table.

exec sp_addtype ‘TAUX’, ‘decimal(5, 2)’, ‘not null’
go

/***** create table dbo.ACMS_TARIF *****/
create table dbo.ACMS_TARIF (
TAR_ID INFO_ID_PT not null,
TAR_EFF_DEB_DAT DAT_PT_V2 not null,
TAR_EFF_FIN_DAT DAT_PT_V2 not null,
TAR_ACMS_TX TAUX(5, 2) not null,
TAR_INF_ABAT TAUX(5, 2) not null,
)

TAUX(5, 2) not null, should be TAUX not null,


#2

Hello Jean-Pierre,

I am able to reproduce this problem in latest build of Toad and CR 108003 is created to deal with this issue. Thanks.