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

2 votes144 views1 answer
Sql create database
SQL
11 votes148 views3 answers
Sqlite3 create table from another table
SQL
2 votes143 views1 answer
Get first 3 letters name in sql
SQL
0 vote150 views1 answer
Sql pivot without aggregate
SQL
0 vote187 views1 answer
Wordpress make wp user in db
SQL
0 vote227 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote154 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote176 views2 answers
What is rownum in oracle
SQL
0 vote144 views1 answer
Sql compound operators
SQL
0 vote177 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL