SQL Server field type enum fields

alcards

Is there an enumerated field in the SQL SERVER field type?
How to achieve

cv4bf5d65fd

Can be customized type

hiqwolfzzh

select t2.name from sysobjects t1, syscolumns t2
where t1.id = t2.id and t1.xtype = 'u' and t1.name = 'table name to enumerate fields'
order by t2.name

fanfan1980

Enumeration type

-
no

hiqwolfzzh

Sorry, misunderstanding just now.
The enum type doesn't seem to be.
Has custom data type

fanfan1980

Custom data types are available

fanfan1980

sp_addtype
Create user-defined data types.

grammar
sp_addtype [@typename =] type,
    [@phystype =] system_data_type
    [, [@nulltype =] 'null_type']
    [, [@owner =] 'owner_name']

----
Check the online help yourself, I don't use much anyway

vgf10002

The custom field type is based on the system field type,
It is not possible to create a custom field type that is not in the system field type

manduoen2006

The ms sql custom data type is a tasteless one, I didn't see any effect.