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

10 votes204 views4 answers
Primary key sql
SQL
3 votes191 views1 answer
Start mysql server linux terminal
SQL
0 vote304 views1 answer
Multiple replace value mssql
SQL
3 votes147 views1 answer
How to get list of synonyms in oracle
SQL
0 vote202 views1 answer
Delete * from where id = 1;
SQL
0 vote199 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote200 views1 answer
Can we rollback in sql
SQL
1 vote235 views1 answer
Sql and
SQL
0 vote191 views1 answer
Mysql find foreign key references
SQL
17 votes223 views5 answers
Order by sql
SQL