Here again, ask: The length of the Decimal data type Thank you

xiaoxu

I created a table in Enterprise Manager. One field is Decimal, and the length is 13 decimal places.
But the default length in Enterprise Manager is 9
Seek a solution
Either build it with a statement or it can be built in Enterprise Manager 管理 Thank you

prajna

Use numeric type

prajna

numeric (13,6)

unkmass

create table test1 (field1 decimal (13,6));

xiaoxu

It seems that the type cannot be changed is the task assigned above

michealhenry

The length cannot be changed
The length of the decimal data type depends on the precision of the column

Modify the precision in the column's property page

fanfan1980

create table T (col decimal (13, 9))

drop table T

--OK

xiaoxu

Thanks
My complete table
zz (table)
A varchar (8)
B varchar (4)
c decimal (13,6)
d date (8) requires A and B to be the joint primary key seek a solution thank you (write a complete thank you with SQL statement)

fanfan1980

create table zz (
A varchar (8) not null,
B varchar (4) not null,
c decimal (13,6) null,
d datetime null,
constraint PK_zz primary key (A, B)
)

fanfan1980

sp_pkeys 'zz'