Does SQL Server have an equivalent to MySQL's ENUM data type?

This works in MySQL version 8.0.12. The syntax is as follows.

create table yourTableName
(
yourColumnName enum(‘Value1’,Value2’,Value3’,......N)
default Value1’ or Value2 or Value3,..N
);

Set the enum type in MySQL with the following query.

mysql> create table EnumInMySQL
-> (
-> WebCRUD enum('CREATE','READ','UPDATE','DELETE')
-> default 'CREATE'
-> );
Query OK, 0 rows affected (0.60 sec)

The syntax of enum in SQL Server.

create table yourTableName
(
yourColumnName varchar(100)
CHECK(yourColumnName IN (‘Value1’,Value2’,Value3’,......N))
DEFAULT ‘Value1’ or Value2’ or Value3’,......N
);

Now the query is as follows for enum in SQL Server.

Chandu yadav

Published on 11-Jan-2019 11:56:53

• Related Questions & Answers
• MySQL LIMIT clause equivalent for SQL SERVER?
• Equivalent of SQL Server IDENTITY Column in MySQL?
• The equivalent of SQL Server function SCOPE_IDENTITY() in MySQL?
• What is MySQL ENUM data type? What are the advantages to use ENUM data type?
• Fix MySQL Error #1064 - You have an error in your SQL syntax… near 'TYPE=MyISAM?
• MySQL ORDER BY 'ENUM' type value based on conditions
• How can I modify an existing column's data type?
• What is the Java equivalent to MySQL's smallint?
• What is the C# Equivalent of SQL Server DataTypes?
• How to call another enum value in an enum's constructor using java?
• C# equivalent to Java's Thread.setDaemon?
• What is the PHP equivalent of MySQL's UNHEX()?
• Equivalent to matlab's imagesc in Matplotlib
• Data Replication from SAP PO to SQL Server
• what are the different attributes of MySQL ENUM data type?