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 vote375 views1 answer
Find and replace query in wordpress\
SQL
0 vote312 views1 answer
Sql server select ignore dupplicates
SQL
0 vote333 views1 answer
Sqlalchemy get schema from database
SQL
2 votes298 views2 answers
Function in sql
SQL
2 votes362 views2 answers
Mysql does sentence contain word
SQL
3 votes360 views3 answers
Mysql auto increment after delete
SQL
0 vote333 views1 answer
Postgres clear table
SQL
0 vote343 views1 answer
Mysql select random rows large table
SQL
-1 vote308 views1 answer
Sql syntax create timestamp column
SQL
1 vote332 views1 answer
Sql pick random row
SQL