数据插入绕不开内码的处理,内码的处理的方案又与主键类型息息相关。那么,金蝶云星空单一主键有哪些数据类型呢?
select system_type_id,count(1) from sys.columns a join
( select TABLE_NAME,max(COLUMN_NAME) COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME not like 'z%' and TABLE_NAME not like 'tmp%'
group by TABLE_NAME having COUNT(1)=1) b on a.object_id=object_id(b.TABLE_NAME) and a.name=b.COLUMN_NAME
group by system_type_id
作为单一主键的数据库数据类型有以下6种:
1、smallint
system_type_id=52 举例:T_BAS_NUMBER.FID
2、int
system_type_id=56 举例:T_BAS_ITEM.FITEMID
3、bigint
system_type_id=127 举例:T_SAL_INITOUTSTOCK.FID
4、varchar
system_type_id=167 举例:T_BAS_PUBNEEDS.FID
5、char
system_type_id=175 举例:CMK_BD_KTMDELETELOG.FID
6、nvarchar
system_type_id=231 举例: T_AM_NETCONTROL.FID
您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!
请选择打赏金币数 *