Enum in SQL Server

USE WorldofWarcraft;

CREATE TABLE [users]
(
   ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
   username nvarchar(255),
   password nvarchar(255),
   mail nvarchar (255),
   [rank]  nvarchar (255) NOT NULL CHECK ([rank] IN('Fresh meat', 'Intern','Janitor','Lieutenant','Supreme being')) DEFAULT 'Fresh meat'
);

Source: stackoverflow.com

Similar codes

5 votes190 views1 answer
Invalid column name sql
SQL
0 vote218 views1 answer
Multiple like values for single column postgres
SQL
0 vote189 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
16 votes192 views1 answer
Mysql reset auto increment value
SQL
0 vote195 views1 answer
How to to get current date in sql
SQL
16 votes199 views1 answer
Mysql mediumint max value
SQL
0 vote193 views1 answer
Mysql in clausule string array
SQL
0 vote226 views1 answer
Sql value exists in column
SQL
0 vote193 views1 answer
Is not null postgresql
SQL
0 vote194 views1 answer
Mysql function variable
SQL