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

5 votes162 views1 answer
Migrate sql table another database
SQL
8 votes162 views2 answers
Phpmyadmin password
SQL
0 vote179 views2 answers
Nested query
SQL
10 votes181 views1 answer
User_dependencies
SQL
0 vote182 views4 answers
Open mysql port bitnami tomact
SQL
1 vote159 views2 answers
T-sql random number for each row
SQL
0 vote179 views1 answer
Ubuntu connect to mssql database
SQL
1 vote173 views1 answer
Mysql list bigger table
SQL
0 vote166 views1 answer
Find largest table in mysql database
SQL
0 vote161 views1 answer
Mysql percentage of total
SQL