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 vote166 views1 answer
Ffeathers express mysql application users login
SQL
0 vote183 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote182 views1 answer
Postgresql function ROUND
SQL
0 vote300 views1 answer
How to find the most occuring in SQL
SQL
3 votes175 views1 answer
Sql replace character in string in all records
SQL
0 vote196 views1 answer
How to change the field size of an existing column
SQL
0 vote162 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote171 views3 answers
How to increase size of column in sql
SQL
0 vote162 views1 answer
Query on date sqlite flutter
SQL
1 vote185 views1 answer
Get parameter value in mysql trigger
SQL