☰

SQL Server equivalent to MySQL enum data type? Ask Question

tag-icon • tag-icon sql sql-server t-sql sql-server-2008 types
SQL Server equivalent to MySQL enum data type? Ask Question

Does SQL Server 2008 have a a data-type like MySQL's enum?

ベストアンサー1

It doesn't. There's a vague equivalent:

mycol VARCHAR(10) NOT NULL CHECK (mycol IN('Useful', 'Useless', 'Unknown'))

おすすめ記事