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 votes165 views3 answers
Sql check double value
SQL
0 vote180 views1 answer
UNION ALL LEFT JOIN
SQL
1 vote146 views1 answer
Deleting database in sql
SQL
1 vote179 views1 answer
Difference between where and having clause
SQL
0 vote143 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
5 votes191 views1 answer
Purge undo tablespace usage
SQL
-1 vote150 views1 answer
Sql oracle take only last results
SQL
0 vote188 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote155 views2 answers
Postgres show current role
SQL
1 vote145 views1 answer
"i_am_a_dummy flag" in MySQL
SQL