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

0 vote107 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote109 views2 answers
Create fulltext index mysql
SQL
9 votes124 views6 answers
Check constraint in sql
SQL
0 vote105 views1 answer
Drop all tables in azure sql database
SQL
0 vote105 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
8 votes111 views1 answer
Oracle search source code
SQL
1 vote118 views1 answer
Mysql select from outside
SQL
0 vote105 views1 answer
T-sql conditional order by multiple columns
SQL
1 vote134 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
19 votes112 views6 answers
Sql create table
SQL