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

1 vote368 views1 answer
Mysql select for update ejemplo
SQL
0 vote408 views1 answer
Mysql create index lost connection
SQL
44 votes458 views4 answers
Mysql alter table add column first
SQL
0 vote342 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote357 views2 answers
Close external port 3306 with iptables
SQL
0 vote358 views1 answer
Mysql search multiple tables
SQL
0 vote379 views1 answer
Make parameters nullable in sql server
SQL
0 vote395 views1 answer
Sql script to remove default from column
SQL
-1 vote366 views1 answer
What is in operator
SQL
0 vote367 views1 answer
Postgres week number
SQL