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

3 votes236 views1 answer
Sql multi column index performance
SQL
1 vote182 views1 answer
Oracle boolean to varchar
SQL
2 votes228 views2 answers
Sql first character
SQL
0 vote232 views1 answer
How to drop a trigger in postgresql
SQL
0 vote238 views1 answer
SQL query to verify the size of the table
SQL
0 vote244 views1 answer
SQL server datetime compare
SQL
7 votes242 views2 answers
Html to react converter
SQL
9 votes239 views4 answers
Postgresql export database
SQL
0 vote275 views1 answer
Sql trim whitespace
SQL
0 vote185 views1 answer
Online sql compiler
SQL